IMPDP Question [message #300622] |
Sat, 16 February 2008 16:26 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #300667 is a reply to message #300661] |
Sun, 17 February 2008 12:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68678 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
|
|
|