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

Reply via email to