dbTalk Databases Forums  

generating DDL from an Oracle isntance

comp.database.oracle comp.database.oracle


Discuss generating DDL from an Oracle isntance in the comp.database.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Corey Wirun - Telus
 
Posts: n/a

Default generating DDL from an Oracle isntance - 04-26-2006 , 10:15 AM






Does anyone know if there is any way to generate table, index DDL from an
installed instance?

Thanks!
C.



Reply With Quote
  #2  
Old   
Jack Miller
 
Posts: n/a

Default Re: generating DDL from an Oracle isntance - 05-09-2006 , 04:12 PM






Try submitting the following query.

select DBMS_METADATA.GET_DDL('INDEX', 'IndexName', 'ownerName')
from DUAL


Thanks,
J


Corey Wirun - Telus wrote:
Quote:
Does anyone know if there is any way to generate table, index DDL from an
installed instance?

Thanks!
C.



Reply With Quote
  #3  
Old   
Aslan
 
Posts: n/a

Default Re: generating DDL from an Oracle isntance - 06-10-2006 , 10:36 AM



another simple choice is to use the sqldeveloper (the new gui tool from
oracle)

Corey Wirun - Telus wrote:
Quote:
Does anyone know if there is any way to generate table, index DDL from an
installed instance?

Thanks!
C.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.