generating DDL from an Oracle isntance

#1

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

Thanks!
C.

#2

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.

#3

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

comp.database.oracle comp.database.oracle