If someone gives you a database, what is the best way to extract its schema in the form of SQL statements so you can recreate the DB (with no data) on a different machine by running the SQL scripts?
Printable View
If someone gives you a database, what is the best way to extract its schema in the form of SQL statements so you can recreate the DB (with no data) on a different machine by running the SQL scripts?
If on 9i you can use DBMS_METADATA. Prior to 9i you can use EXPORT with ROWS=N or some reverse engineering scripts and third party tools like toad, databee etc.
HTH