generate schema script
When I look at the content of an exported file, it contains a header followed by basically bunch of SQL statements.
If I have an existing database but don't have the scripts to recreate schema (including constraints, etc.), the best way to generate a script for the schema is to extract from the content of the exported file? Is it a reliable way?
Is there a better way to generate a script for the schema in an existing DB?
Last edited by a128; 12-05-2002 at 07:14 PM.
Just do a simple import with rows=n, that way u will get all ur schemas (users,tables,indexes,views,constraints,procedures,packages,triggers etc) excluding data.
If you want to create a set of schema build scripts take a look at the free datatool at http://www.databee.com
If you follow Amar's advice the datatool above reads the exprt file and produces the schema defintion.
It's quite neat and save a lot of time.
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
Click Here to Expand Forum to Full Width