-
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,
-
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