Re: recreating a create database file

From: Thomas Day <tday6_at_csc.com>
Date: Tue, 17 Jun 2003 07:16:23 -0700
Message-ID: <F001.005B2E4B.20030617065954@fatcity.com>

Do you need the "CREATE DATABASE ..." script or the scripts to create all the database objects. If it's the latter and you have an export, import that into an IFILE and remove all the REMs. That should give you the tablespaces, tables, and indexes. You'll have to do some manual formatting.

                                                                                       
                                                
                      "Ruth Gramolini"                                                 
                                                
                      <rgramolini              To:      Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>                    
                      @tax.state.vt.us         cc:                                     
                                                


                      >                        Subject: recreating a create database 

file                                              
                      Sent by:                                                         
                                                
                      ml-errors                                                        
                                                
                                                                                       
                                                
                                                                                       
                                                
                      06/17/2003 10:09                                                 
                                                
                      AM                                                               
                                                
                      Please respond                                                   
                                                
                      to 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: Thomas Day
  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).

Received on Tue Jun 17 2003 - 09:16:23 CDT