Re: Wizards for generating scripts

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Fri, 09 Jul 2004 12:46:49 GMT
Message-ID: <ZswHc.12776$Rf.4922@edtnps84>

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

What are you trying to accomplish?

The reason I ask - it sounds very much like you want to recreate a SCHEMA, not a DATABASE (note the overloaded terminology .... Oracle SCHEMA is roughly equal to MS SQLServer Database)

Under many circumstances that I envision, recreating Oracle databases is a bad idea. Following are some of the reasons:

If Attempting to do distribute a product overrides the customer's DBA management policies (use scripts, such as generated by OEM CHange Mgt Pack or Oracle Designer or Erwin ...)
If attempting to bring back a damaged data set, use RECOVERY, not recreate
If attempting to set up one or more temp tables as in TSql requirements, this will likely have a bad impact on performance

If recreate an Oracle database, learn about DBCA

If recreate one or more SCHEMA, learn about exp/imp (Oracle Utilities document) Received on Fri Jul 09 2004 - 07:46:49 CDT