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

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

Re: Obtaining DDL creation scripts from oracle

From: <eoin7_at_my-deja.com>
Date: Wed, 23 Jun 1999 17:32:38 GMT
Message-ID: <7kr5nm$d3l$1@nnrp1.deja.com>


Wouldn't it be easier to do a full export from this database, create a new database and import? You would just need to make sure you have the same set of tablespaces on the newly created database.

If you can use Oracle Designer, you can reverse engineer the database and generate all the ddl.

In article <7kr53d$crs$1_at_nnrp1.deja.com>,   jbastias_at_stirlingdouglas.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.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 23 1999 - 12:32:38 CDT

Original text of this message

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