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
lokhande.dinesh29
Messages: 36
Registered: May 2007
Member
Hi all,

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

Regards,
dinesh
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
Maaher
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.

MHE
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: 64119
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).

Regards
Michel
Previous Topic: Problem: ORA-00980: synonym translation is no longer valid
Next Topic: Question on Object
Goto Forum:
  


Current Time: Tue Dec 06 08:49:36 CST 2016

Total time taken to generate the page: 0.12781 seconds