Home » RDBMS Server » Server Utilities » IMPDP Question (Oracle 10g Server 2003)
IMPDP Question [message #300622] Sat, 16 February 2008 16:26 Go to next message
tkaufman40
Messages: 3
Registered: February 2008
Junior Member
I am using DataPump with NETWORKLINK and was wondering can I Import without dropping the user.

The command I am using is...

system/********@USER directory=DATA_PUMP_IL10 network_link=NETLINKIL10 FULL=n TABLE_EXISTS_ACTION=REPLACE.

I usually drop the user before but if I can skip that step and have a successful import that would be great. If not is there a better way to do this?
Re: IMPDP Question [message #300623 is a reply to message #300622] Sat, 16 February 2008 16:41 Go to previous messageGo to next message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
What are you trying to do?is it schema level import you are doing ?if so yo can't drop the user,if full yes.
Re: IMPDP Question [message #300624 is a reply to message #300623] Sat, 16 February 2008 16:56 Go to previous messageGo to next message
tkaufman40
Messages: 3
Registered: February 2008
Junior Member
I have currently three Schema's I am trying to transfer to another server on a scheduled basis as a secondary server. The secondary server would be used only if the other server is down.
Re: IMPDP Question [message #300633 is a reply to message #300624] Sun, 17 February 2008 00:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Your solution is DataGuard not export/import.

Regards
Michel
Re: IMPDP Question [message #300661 is a reply to message #300633] Sun, 17 February 2008 10:45 Go to previous messageGo to next message
tkaufman40
Messages: 3
Registered: February 2008
Junior Member
From what I have read I agree getting others in my comapany onboard with RMan and DataGuard probably will never happen.

Thanks
Re: IMPDP Question [message #300667 is a reply to message #300661] Sun, 17 February 2008 12:28 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And they find their export/import process fails many times, above all if it fails during a failure of the primary database, they will change their mind.
Anyway, suggest this solution and noone can/will blame you to not having warned and recommended another solution.

Regards
Michel
Previous Topic: best way for nightly exports
Next Topic: Error using IMP (importing a schema)
Goto Forum:
  


Current Time: Fri Dec 02 20:37:31 CST 2016

Total time taken to generate the page: 0.11847 seconds