For 8I : IMP SYSTEM/MANAGER@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: [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: Babich , Sergey 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).
