Hello,

I need to split a Oracle 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 !

On Sat, 16 Sep 2006 21:22:21 +0200, Seb <arx9qekubvq93e3 (AT) jetabe (DOT) net>
wrote:


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.

--
Sybrand Bakker, Senior Oracle DBA

Sybrand Bakker wrote:
But then again, not meaning to be rude to the OP, 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:
Seb, if you also need to know how to generate the DDL for Oracle
objects see the Suppled PL/SQL Packages and Types manual or equivilent
for your release of Oracle (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:
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 OP states that script file already exists.

-- Mark --

How about using TOAD? It got all the options.