| 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
Tom,
Yes the trace file is a good idea for scripting the database ut it
does not create any of the tables and other options available in Oracle.
You will still need all of your scripts or other package to completely
recreate your database.
That is if the interpretation of a database is more than just
datafiles.
Ron
>>> [EMAIL PROTECTED] 06/17/03 01:44PM >>>
Golly, this is the best answer!!!
Great idea Jeremiah!!!!
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Tuesday, June 17, 2003 12:40 PM
To: Multiple recipients of list ORACLE-L
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 - 13:40:10 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F 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: Ron Rogers 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).
 |
 |