Hello,
I need to split a data definition SQL script file (DDL script) to
many files, each file corresponding to one command category (table
creation, constraint creation, index creation, etc).
Do you know some tool to do that ?
Thanks in advance for your answers !

Sybrand Bakker wrote:
Sat, 16 Sep 2006 21:22:21 +0200, Seb <arx9qekubvq93e3@jetabe.net>
wrote:
>
>Hello,
>
>I need to split a data definition SQL script file (DDL script) to
>many files, each file corresponding to one command category (table
>creation, constraint creation, index creation, etc).
>Do you know some tool to do that ?
>
>Thanks in advance for your answers !
>
>
awk, vi and sed come to mind. If you are on Windows, gvim is a vi
clone for Windows, www.gvim.org If you need awk and sed too you can
download Cygwin, which is (korn)shell clone for Windows.

And then of course Perl could do it.

Perl! Perl! Perl! :-) (Is there anything you can't use it for?)
But then again, not meaning to be rude to the P, someone asking this
question will probably not be able to make Perl do it.

cheers,
Martin

p.s.: I agree that this post was not really helpful.

Martin T. wrote:
Sybrand Bakker wrote:
Sat, 16 Sep 2006 21:22:21 +0200, Seb <arx9qekubvq93e3@jetabe.net>
wrote:
>
>Hello,
>
>I need to split a data definition SQL script file (DDL script) to
>many files, each file corresponding to one command category (table
>creation, constraint creation, index creation, etc).
>Do you know some tool to do that ?
>
>Thanks in advance for your answers !
>
>
awk, vi and sed come to mind. If you are on Windows, gvim is a vi
clone for Windows, www.gvim.org If you need awk and sed too you can
download Cygwin, which is (korn)shell clone for Windows.

And then of course Perl could do it.

Perl! Perl! Perl! :-) (Is there anything you can't use it for?)
But then again, not meaning to be rude to the P, someone asking this
question will probably not be able to make Perl do it.

cheers,
Martin

p.s.: I agree that this post was not really helpful.

Seb, if you also need to know how to generate the DDL for
objects see the Suppled PL/SQL Packages and Types manual or equivilent
for your release of (8.1 up I believe) for the DBMS_METADATA
package.

Also the indexfile parameter of imp covered in the Utilities manual may
be of interest for table and index definitions. The previously
mentioned Unix utilities can be used on the results of the imp Show
parameter to cut out DDL from an import file.

Version 10 impdp also has some DDL extract options but I do not
remember the parameter name off the top of my head and rather than open
the manual I will leave that to you if you need the feature.

HTH -- Mark D Powell --

Mark D Powell wrote:
Martin T. wrote:
Sybrand Bakker wrote:
Sat, 16 Sep 2006 21:22:21 +0200, Seb <arx9qekubvq93e3@jetabe.net>
wrote:
>
>Hello,
>
>I need to split a data definition SQL script file (DDL script) to
>many files, each file corresponding to one command category (table
>creation, constraint creation, index creation, etc).
>Do you know some tool to do that ?
>
>Thanks in advance for your answers !
>
>
awk, vi and sed come to mind. If you are on Windows, gvim is a vi
clone for Windows, www.gvim.org If you need awk and sed too you can
download Cygwin, which is (korn)shell clone for Windows.

And then of course Perl could do it.

Perl! Perl! Perl! :-) (Is there anything you can't use it for?)
But then again, not meaning to be rude to the P, someone asking this
question will probably not be able to make Perl do it.

cheers,
Martin

p.s.: I agree that this post was not really helpful.

Seb, if you also need to know how to generate the DDL for
objects see the Suppled PL/SQL Packages and Types manual or equivilent
for your release of (8.1 up I believe) for the DBMS_METADATA
package.

Also the indexfile parameter of imp covered in the Utilities manual may
be of interest for table and index definitions. The previously
mentioned Unix utilities can be used on the results of the imp Show
parameter to cut out DDL from an import file.

Version 10 impdp also has some DDL extract options but I do not
remember the parameter name off the top of my head and rather than open
the manual I will leave that to you if you need the feature.

HTH -- Mark D Powell --
I meant to reword the start to read more along the lines that if
thought it would be easier to extract the DDL on an object by object or
associated object basis that the tools I mentioned might be of interest
since the P states that script file already exists.
-- Mark --

How about using TAD? It got all the options.