Re: Obtaining DDL creation scripts from oracle

Oracle has Designer 2000 which will do reverse engineering. Also, a product called ERwin will do it.

Another way is do a full export of the database not including data. Then when you run import use the following command:

imp show=y log=mydb.txt

Instead of doing the import it will write all of the create DDL to the file mydb.txt. You will have to go in a take out the " marks, but you will have the scripts.

Kenny Gump

jabastias_at_my-deja.com wrote in message <7kr53d$crs$1_at_nnrp1.deja.com>...
>Hi all,
>
>This is a bit of a newbie question. I have an existing oracle (v7.3.x)
>database but I don't have DDL source used to create it I would like to
>'clone' a clean version of the database. I'd like to know if there is
>some way to get the oracle server to generate the DDL for an existing
>database and dump it to a file for future use.
>
>I know all the information I need is in the system tables, but I don't
>want to have to write a program to generate the DDL for me unless I
>absolutely have to.
>
>I know that SQL Server has a system stored proc which does it (not to
>mention that it is a menu item in the enterprise manager, sp_helptext).
>
>Thanks
>Jorge
>
>Please response to jbastias_at_stirlingdouglas.com
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Jun 24 1999 - 13:03:49 CDT