| 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 #569705 is a reply to message #569698] |
Wed, 31 October 2012 08:01  |
John Watson
Messages: 8968
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
