OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » impdp (11.2.0.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: impdp [message #609716 is a reply to message #609711]

Tue, 11 March 2014 08:04

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Your best bet is to read the documentation and ask further questions from there.

HTH
-g

Report message to a moderator

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

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 16 14:23:27 CDT 2025