Not sure if this was already mentioned.  You can hack up the result of
this:

alter database backup controlfile to trace;

into an exact replica of the create database statement.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Tue, 17 Jun 2003, Jack van Zanen wrote:

> Maybe not exactly what you are looking for, but....
> 
> 
> Start the GUI DBCA (NO don't shoot), go through the all the motions and at
> the end choose generate scripts only.
> 
> Jack
> 
> 
> 
> 
> 
> 
> 
> -----Original Message-----
> Sent: Tuesday, June 17, 2003 4:09 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Good morning all,
> 
> Somehow all of my scripts to create the databases on my 9i sandbox have
> disappeared.  Does anyone have a script or trick or something to recreate
> these files?  I could recreate them manually but I am somewhat of a time
> crunch.
> 
> Thanks in advance,
> Ruth
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Ruth Gramolini
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California        -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
> message BODY, include a line containing: UNSUB ORACLE-L (or the name of
> mailing list you want to be removed from).  You may also send the HELP
> command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jack van Zanen
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California        -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremiah Wilton
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Reply via email to