Home » RDBMS Server » Server Utilities » impdp (
impdp [message #609711] Tue, 11 March 2014 07:45 Go to next message
Messages: 451
Registered: May 2008
Senior Member

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.

Re: impdp [message #609716 is a reply to message #609711] Tue, 11 March 2014 08:04 Go to previous messageGo to next message
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Your best bet is to read the documentation and ask further questions from there.

Re: impdp [message #609732 is a reply to message #609711] Tue, 11 March 2014 09:41 Go to previous message
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
. . . 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

Previous Topic: impdp
Next Topic: date format in control file (sql loader)
Goto Forum:

Current Time: Sat May 25 02:47:53 CDT 2024