Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Solution to generate scripts to recreate database
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 DBAReceived on Thu Sep 13 2007 - 07:06:14 CDT