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).
Received on Tue Feb 05 2002 - 09:13:46 CST
