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: Wizards for generating scripts

Re: Wizards for generating scripts

From: Glen A Stromquist <glen_stromquist_at_no_spam_yahoo.com>
Date: Fri, 09 Jul 2004 16:05:35 GMT
Message-ID: <jnzHc.15953$eO.10389@edtnps89>


Ernest Morariu wrote:
> Hi!
>
> Is there in the Oracle 9i a wizard that could help me to generate the script
> for the (re)creation of an existing database ?
>
> I need something similar to the wizard "Generate Sql Script..." in MS
> SqlServer 2000.
>
> Ernest
>
>
>
>
>

Been awhile since I've done it, but if I remember correctly the trace file generated from "alter database backup controlfile to trace" can be edited to create a database thats the same (or as similar as you want it) as the source database.

hth Received on Fri Jul 09 2004 - 11:05:35 CDT

Original text of this message

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