I just logged on to sqlplus using the logon / as
sysdba and did an 'alter controlfile backup controlfile to trace;' This
creates a file in your dump destination. Then you can recreate the db
using this file.
HTH,
Ruth
----- Original Message -----
Sent: Tuesday, June 17, 2003 1:29
PM
Subject: Re: recreating a create database
file
Ruth,
Ummm how did you do this in 9i?
Thanks,
I
got the answer, thanks anyway. Ruth ----- Original Message -----
To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 10:09
AM
> 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: 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).
Do you Yahoo!? SBC
Yahoo! DSL - Now only $29.95 per month!
|