Home » RDBMS Server » Server Utilities » impdp (11.2.0.3)
impdp [message #609711] Tue, 11 March 2014 07:45 Go to next message
pointers
Messages: 350
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 #609716 is a reply to message #609711] Tue, 11 March 2014 08:04 Go to previous messageGo to next message
gazzag
Messages: 316
Registered: November 2010
Location: Bristol, UK
Senior Member
Your best bet is to read the documentation and ask further questions from there.

HTH
-g
Re: impdp [message #609732 is a reply to message #609711] Tue, 11 March 2014 09:41 Go to previous message
LKBrwn_DBA
Messages: 436
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

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


Current Time: Thu Sep 18 13:38:00 CDT 2014

Total time taken to generate the page: 0.11761 seconds