What is the best tool for generating DDL of entire database? [message #358257] |
Mon, 10 November 2008 06:25  |
Andre1
Messages: 4 Registered: November 2008 Location: London
|
Junior Member |
|
|
Hello, I've developed a database using Oracle's free tool 'SQL Developer'. My DBA has asked for a DDL script which he can use to recreate the entire database (excluding data) in a new database (he wants a script rather than a dump-file so that he can examine the script before running it).
SQL Developer has a tool for generating such a script, but it doesn't seem to pay much attention to the order in which the DDL statements are generated: this means that when you try to run the script as-is in another database you get error messages due to things like Views referring to Functions which haven't been created yet.
So far, I've been manually editing these scripts to put the DDL in the right order, but this is tedious and I'm wondering if there's a better way! I'd appreciate any ideas.
|
|
|
|
|