Home » SQL & PL/SQL » SQL & PL/SQL » Get ddl from Oracle8
Get ddl from Oracle8 [message #241274] Tue, 29 May 2007 01:35 Go to next message
Messages: 36
Registered: May 2007
Hi all,

can anybody give me the code to fetch ddl's from oracle8.

Re: Get ddl from Oracle8 [message #241279 is a reply to message #241274] Tue, 29 May 2007 01:42 Go to previous messageGo to next message
Messages: 7062
Registered: December 2001
Senior Member
I would probably use Oracle's Export Utility. Use the switch rows=n to avoid data extraction.

You could also try reconstructing the DDL from the dictionary (user_tables, user_synonyms, user_source, ...) but that's not really easy. On the other hand, I believe that there are scripts on the net that do this.

Re: Get ddl from Oracle8 [message #241280 is a reply to message #241274] Tue, 29 May 2007 01:45 Go to previous message
Michel Cadot
Messages: 65154
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Depends on which DDL you want (tables, views, procedures, sequences...)
As Maarten said, you can generate them from Oracle catalog some are easy other much more difficult.

Many tools can do it for you (for instance TOAD).

Previous Topic: ORA-00604 problem
Next Topic: query on update
Goto Forum:

Current Time: Wed Aug 23 10:50:53 CDT 2017

Total time taken to generate the page: 0.06387 seconds