Re: test schema from prod

From: <DBarbour_at_austin.isd.tenet.edu>
Date: Mon, 17 Sep 2001 11:21:53 -0700
Message-ID: <F001.00390839.20010917094029@fatcity.com>

Restore a backup of your production DB to another box and rename it. Great practice for recovery as well. If you need help renaming the DB after you've got it restored (big hint - create controlfile), let us know.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

                                                                                       
                       
                    "Raghu Kota"                                                       
                       
                    <raghukota_at_hot       To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>  
                    mail.com>            cc:                                           
                       
                    Sent by:             Subject:     test schema from prod            
                       
                    root_at_fatcity.c                                                     
                       
                    om                                                                 
                       
                                                                                       
                       
                                                                                       
                       
                    09/17/2001                                                         
                       
                    10:35 AM                                                           
                       
                    Please respond                                                     
                       
                    to ORACLE-L                                                        
                       
                                                                                       
                       
                                                                                       
                       

Hi Friends,

I want to create test schema from my production database, What is best way to do that!! Any ideas or ways to create test schema fast!! I appreciate your time.

TIA
Raghu.

---

Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Raghu Kota
  INET: raghukota_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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.com
-- 
Author: 
  INET: DBarbour_at_austin.isd.tenet.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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 Mon Sep 17 2001 - 13:21:53 CDT