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: Solution to generate scripts to recreate database

Re: Solution to generate scripts to recreate database

From: sybrandb <sybrandb_at_gmail.com>
Date: Thu, 13 Sep 2007 05:06:14 -0700
Message-ID: <1189685174.799235.183570@y42g2000hsy.googlegroups.com>


On Sep 13, 12:15 pm, "Shakespeare" <what..._at_xs4all.nl> wrote:
> <fitzjarr..._at_cox.net> schreef in berichtnews:1189629501.931650.159850_at_w3g2000hsg.googlegroups.com...
>
>
>
>
>
> > On Sep 12, 3:17 pm, sybra..._at_hccnet.nl wrote:
> >> On Wed, 12 Sep 2007 14:39:06 -0500, Brian Peasland
>
> >> <d..._at_nospam.peasland.net> wrote:
> >> >Depending on what you mean by recreating a database...the
> >> >DBMS_METADATA.GET_DDL procedure can be used to reverse engineer many
> >> >CREATE statements.
>
> >> The CREATE DATABASE statement is not one of them, at least not in 9i.
>
> >> --
>
> > No one creates databases with scripts anymore? I save my database
> > creation scripts so I have them later in the event something
> > disastrous happens.
>
> > David Fitzjarrell
>
> >>>> No one creates databases with scripts anymore? <<<<
>
> Of course not! Why use scripts when tools loke TOAD can create databases for
> us? ;-)))
>
> Shakespeare- Hide quoted text -
>
> - Show quoted text -

Last time I looked Toad was uncapable of regenerating the CREATE DATABASE statement.

--
Sybrand Bakker
Senior Oracle DBA
Received on Thu Sep 13 2007 - 07:06:14 CDT

Original text of this message

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