Re: Obtaining DDL creation scripts from oracle

From: Van Messner <vmessner_at_netaxis.com>
Date: Wed, 23 Jun 1999 20:11:59 -0400
Message-ID: <IPec3.4017$vN3.183885@typ32b.nn.bcandid.com>

Everyone has given you an Oracle solution and they should all work. We often want to clone a production database for testing. We simply shut down the database at night, take an operating system copy, load it on to another server and we're in business.

Van

<jabastias_at_my-deja.com> wrote in message news: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 Wed Jun 23 1999 - 19:11:59 CDT