Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Obtaining DDL creation scripts from oracle

Re: Obtaining DDL creation scripts from oracle

From: Marc Mazerolle <informaze_at_sympatico.ca>
Date: Wed, 23 Jun 1999 17:35:52 GMT
Message-ID: <37711C6D.82CF525D@sympatico.ca>


Download demo version of DBArtisan from Embarcadero at www.embarcadero.com. Install it, generate the DDL of your database and then remove it (oh ya, you could also buy it if you have the budget for it).

Regards,

Marc Mazerolle
InforMaze Technologies

jabastias_at_my-deja.com wrote:

> 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:35:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US