impdp [message #609711] |
Tue, 11 March 2014 07:45 |
pointers
Messages: 451 Registered: May 2008
|
Senior Member |
|
|
Hi,
I have exported the database full using expdp and started impdp to load data on new server.
impdp strucked so i killed the session. Now, I do see there are couple of schemas created on new server.
I wanted to do the impdp again, so i tried to do
drop user .. cascade
but there are many schemas and each taking so much time.
now my question is, does oracle takes care of loading things where it stopped if I run the impdp again or do i need to drop all the schemas and objects.
Thank you in advance.
Regards,
Pointers
|
|
|
|
Re: impdp [message #609732 is a reply to message #609711] |
Tue, 11 March 2014 09:41 |
|
LKBrwn_DBA
Messages: 487 Registered: July 2003 Location: WPB, FL
|
Senior Member |
|
|
Quote:. . . impdp strucked so i killed the session.
By being impatient you only increased the time it will take you to load that new database and now you are trying to look for "short-cuts". There are no short-cuts, do things correctly and you will succeed.
To speed-up datapump, you could have used:
1) the parallel option or
2) transportable tablespaces
[Updated on: Tue, 11 March 2014 09:55] by Moderator Report message to a moderator
|
|
|