Generating DDLs of Existing tables [message #20646] |
Mon, 10 June 2002 20:15 |
P.Deshmukh
Messages: 17 Registered: March 2002
|
Junior Member |
|
|
Hello everybody,
We can take the source of views,stored procedures,packages,triggers from data dictionary. But,how can generate DDLs of existing table with all existing constraints?
Pl. help me out, thanks in advance!
|
|
|
Re: Generating DDLs of Existing tables [message #20649 is a reply to message #20646] |
Tue, 11 June 2002 03:26 |
|
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
There are such tools as TOAD/SQL Navigator.... (I mention these, but there are more of them). At the Quest website, you can download a trial version.
And on the other hand, in Oracle9i you have DBMS_METADATA which takes care of this for you.
Perhaps, you could create a similar script on your own, all information is provided in user_tables, user_constraints, user_triggers. But user_triggers and user_constraints contain LONG fields, that could complicate things a bit.
HTH,
MHE
|
|
|
|