export/import on the same server

From: Farnsworth, Dave <DFarnsworth_at_Ashleyfurniture.com>
Date: Tue, 05 Feb 2002 06:32:07 -0800
Message-ID: <F001.00406169.20020205062034@fatcity.com>

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). Received on Tue Feb 05 2002 - 08:32:07 CST