| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: recreating a create database file
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:Received on Tue Jun 17 2003 - 11:30:24 CDT
> 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).
 |
 |