-
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
-
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
Performance... Push the envelope!
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|