OraFAQ Forum: Server Utilities » Issue/failure in IMPDP

Home » RDBMS Server » Server Utilities » Issue/failure in IMPDP (11.2.0.3)

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

Issue/failure in IMPDP [message #569698]

Wed, 31 October 2012 07:01

suddhasatwa_bhaumik
Messages: 18
Registered: October 2011
Location: India

Junior Member

Hello All

I am in middle of a strange issue.

I took EXPDP of a 10.2.0.3 database whose DB size is 800GB from Solaris. Then I am doing an IMPDP into a blank database in windows 2008 server. Target DB version is 11.2.0.3. It ran well for 2-3 days continously (!!) and then failed because there was not enough space in TEMP tablespace.

As I can see now, in the test DB where I was importing, the data size is 410GB out of total 750GB which is size of the primary/source database.

Is there any way/option in IMPDP wherein I can now re-start it from where it failed?

For further information please let me know.

Thanks.

[Updated on: Wed, 31 October 2012 07:02]

Report message to a moderator

Re: Issue/failure in IMPDP [message #569702 is a reply to message #569698]

Wed, 31 October 2012 07:30

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Maybe. Depends on how the job was closed.
http://blog.oracle48.nl/killing-and-resuming-datapump-expdp-and-impdp-jobs/

Report message to a moderator

Re: Issue/failure in IMPDP [message #569705 is a reply to message #569698]

Wed, 31 October 2012 08:01

John Watson
Messages: 8978
Registered: January 2010
Location: Global Village

Senior Member

Enabling resumable space allocation will help for your next try: if it hangs on the space issue, you'll get the chance to add more and then it will continue, rather than failing.

Report message to a moderator

Re: Issue/failure in IMPDP [message #569708 is a reply to message #569705]

Wed, 31 October 2012 08:46

suddhasatwa_bhaumik
Messages: 18
Registered: October 2011
Location: India

Junior Member

Thanks. I cannot see any rows as output of the "select * from dba_datapump_jobs;" query.
Please advice how I can enable resumable space allocation in EXPDP.

Report message to a moderator

Previous Topic:	About sql loader
Next Topic:	Error while importing a dump file in Oracle 10g R1

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 15 20:47:05 CDT 2025