RE: export/import on the same server

From: Babich , Sergey <SBabich_at_handexmail.com>
Date: Tue, 05 Feb 2002 08:13:43 -0800
Message-ID: <F001.004062A4.20020205072521@fatcity.com>

For 8I : IMP SYSTEM/MANAGER_at_TEST file=path_to_your_dump_file/file_name.dmp FULL=Y .......MORE....Read on the parameters. I would drop all the users cascade( except sys,system,outln etc.) in the test database prior to import. Don't bother using DESTROY. Everything will go to where your TEST datafiles sit.
Regards,
Sergey

-----Original Message-----
Sent: Tuesday, February 05, 2002 9:21 AM

To:     Multiple recipients of list ORACLE-L
Subject:        export/import on the same server

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Babich , Sergey
INET: SBabich_at_handexmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------