Re: export/import on the same server

From: <Rick_Cale_at_teamhealth.com>
Date: Tue, 05 Feb 2002 08:09:55 -0800
Message-ID: <F001.00406355.20020205075521@fatcity.com>

Dave,

If you are in a position to shutdown prod. I would think it would be easier to copy all prod datafiles,etc to test location and recreate the control file on test to point to correct directory and your there. If you need more detail I can provide.

Rick

                                                                                       
                            
                    Rachel                                                             
                            
                    Carmichael           To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>       
                    <wisernet100@        cc:                                           
                            
                    yahoo.com>           Subject:     Re: export/import on the same 
server                         
                    Sent by:                                                           
                            
                    root_at_fatcity.                                                      
                            
                    com                                                                
                            
                                                                                       
                            
                                                                                       
                            
                    02/05/2002                                                         
                            
                    10:05 AM                                                           
                            
                    Please                                                             
                            
                    respond to                                                         
                            
                    ORACLE-L

Dave,

are you planning on completely dropping the TEST database and recreating it from the PROD export? If so, you are right to be cautious.

If you want to refresh the data and the number of schema owners is small, you might consider just dropping the users and their objects then recreating the users in the TEST database.

Then you can just import fromuser= touser= and make sure that you are pointing to the TEST database (I'd log in via sqlnet, even though they are on the same box:

imp testdba/testdbapassword_at_test file= fromuser= touser= etc

If that won't work, then the next best thing to do would be to drop and recreate the TEST database, tablespaces/datafiles and all. Then use IGNORE=Y and DESTROY=N and again MAKE SURE YOU ARE POINTING TO TEST when you do the import.

"Farnsworth, Dave" <DFarnsworth_at_Ashleyfurniture.com> wrote:
> I have a question on the export/import utility. I have my live(PROD)
> and test(TEST) databases are on the same server. These are basically
> the same schemas except that the data in TEST is old and that the
> datafiles for PROD are on I: drive and the datafiles for TEST are on
> E:
> drive.
> My question is, since these are on the same server do I have to worry
> about which data files will be written to during the import. For
> example;
> I do a full export of my PROD database. When I do my import into my
> TEST database will the data automatically go to E: drive or will it
> still be pointing to I: drive? I am reading the Import section of
> the
> fine manual but am a bit confused on the datafiles part of it when
> doing
> a full export/import. Do I need to use the DESTROY=N parameter?
> I am new to this utility but want to learn it. I am reading the
> manuals
> and some other reading material but still am not clear on this. I do
> not want it to start overwriting my live data. That is not good for
> job
> security.
>
> Thanks,
>
> Dave
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Farnsworth, Dave
> INET: DFarnsworth_at_Ashleyfurniture.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).

Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.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: Rick_Cale_at_teamhealth.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).

Received on Tue Feb 05 2002 - 10:09:55 CST