Home » RDBMS Server » Server Utilities » Issue/failure in IMPDP (11.2.0.3)
Issue/failure in IMPDP [message #569698] Wed, 31 October 2012 07:01 Go to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10613
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/
Re: Issue/failure in IMPDP [message #569705 is a reply to message #569698] Wed, 31 October 2012 08:01 Go to previous messageGo to next message
John Watson
Messages: 4101
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.
Re: Issue/failure in IMPDP [message #569708 is a reply to message #569705] Wed, 31 October 2012 08:46 Go to previous message
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.

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


Current Time: Wed Apr 23 11:30:23 CDT 2014

Total time taken to generate the page: 0.13909 seconds