Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Obtaining DDL creation scripts from oracle
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 Wed Jun 23 1999 - 12:22:02 CDT