Ron, I read Ruth's original message meaning that she had to re-create the database structures. Of course you are correct if she meant the schema objects also.
I just liked Jeremiah's thinking - this is an excellent quick way of creating the "create database" script to re-create all of the physical structure. Much easier than trying to create a sql-script to generate the same. Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Tuesday, June 17, 2003 2:55 PM To: Multiple recipients of list ORACLE-L 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: > 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). -- 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).
