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
<[EMAIL PROTECTED]>
<wisernet100@ cc:
yahoo.com> Subject: Re: export/import on the same
server
Sent by:
root@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@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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
>
> 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: [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!?
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: [EMAIL PROTECTED]
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: [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.com
--
Author:
INET: [EMAIL PROTECTED]
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: [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).
