-
generate schema script
Hi,
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?
Thanks,
Last edited by a128; 12-05-2002 at 08:14 PM.
-
Hi
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.
Regards
Amar
-
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.
Regards
Jim
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!
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
|