Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: export/import on the same server

RE: export/import on the same server

From: Farnsworth, Dave <DFarnsworth_at_Ashleyfurniture.com>
Date: Tue, 05 Feb 2002 12:16:19 -0800
Message-ID: <F001.00406A4B.20020205121631@fatcity.com>

Is it necessary to drop the users and/or their objects? I guess I was not planning on dropping them. The "IGNORE=Y", will this cause the import to skip an object if it already exists, but it will still import the data???

Thanks again Rachel,

Dave

-----Original Message-----
Sent: Tuesday, February 05, 2002 1:25 PM To: Multiple recipients of list ORACLE-L

yes that should work because you aren't doing a full db import which is the only way you can destroy the files.

I might do "ignore=y" as well

are you going to drop the users first, drop just their objects or only truncate the objects?

if you drop the users, you will need to recreate them or the import will load everything into "mylogin"

for safety's sake, I'd probably run the import once for each user, and have "fromuser=" and "touser=" in the parfile


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).
--
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 - 14:16:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US