Extract DDLs for schema

[akka]

Hi,
I am looking for a script that could extract complete DDLs from a schema in a text file format.

( P.s I don't want to use export utility to do this)

Thanks

[roobaron]

I was going to point you to a SQL script from razsoft.com looks like they are extinct!
I have the script, email me if you want it.
You might like to do a search on the internet. There may be a SQL script out there somewhere

Have Fun

[rohitsn]

HI,
The best way to extract complete DDL from a schema is through the export dum file.Enter the follwoing command and u will get the DDL syntax for all the objects in ur schema.


imp sys file=export.dmp log=a.log fromuser=scott touser=scott rows=n indexes=n grants=n constraints=n commit=y ignore=y indexfile=scripts.sql

When u run the above import command Oracle will extract all the DDL statements from the export dum file into scripts.sql
file.

In case of any help please be free to ask me at rohitsn@altavista.com


Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
rohitsn@altavista.com