GouthamAnand
asked on
Oracle 11g Import job impdp
Hi,
I got the below error while importing the data for few tables using impdp in Oracle 11g.
"ORA-39171: Job is experiencing a resumable wait."
then I added data files with autoextend on and maxsize as unlimited and re-started the import job.
Can you please let me know if my job impot the tables for which I got the error like above?
If not, should I manully import those tables after the complete import and my import job is completed?
Also, before the error I added the datafile with autoextend on but did not give "maxsize unlimited". Is that the reason for the error?
For my case it extend upto 31 gb but still lot of space is available in the drive. But did not get extended.
If I do not give maxsize for autoextend on, upto how much size it will extend(default size) ?
Even after I gave maxsize unlimited(second time when i add datafile) I got the same error after reaching 31.9 GB. Still there is lot of space in the hard disk.
Can you please let me know why I am getting this error.
Anyway I added more datafiles and continuing the job.
Thanks.
I got the below error while importing the data for few tables using impdp in Oracle 11g.
"ORA-39171: Job is experiencing a resumable wait."
then I added data files with autoextend on and maxsize as unlimited and re-started the import job.
Can you please let me know if my job impot the tables for which I got the error like above?
If not, should I manully import those tables after the complete import and my import job is completed?
Also, before the error I added the datafile with autoextend on but did not give "maxsize unlimited". Is that the reason for the error?
For my case it extend upto 31 gb but still lot of space is available in the drive. But did not get extended.
If I do not give maxsize for autoextend on, upto how much size it will extend(default size) ?
Even after I gave maxsize unlimited(second time when i add datafile) I got the same error after reaching 31.9 GB. Still there is lot of space in the hard disk.
Can you please let me know why I am getting this error.
Anyway I added more datafiles and continuing the job.
Thanks.
ASKER
Yes. Thank you. But my question is not how to resolve the error. As it was explained in the website. But Want to know the root cause of the error ie even after giving the autoextend on (with or without maxsize) got the error?
Also. another question is what about for the tables for which already got the error "ORA-39171: Job is experiencing a resumable wait."
does it retry for those tables also?
Thanks.
Also. another question is what about for the tables for which already got the error "ORA-39171: Job is experiencing a resumable wait."
does it retry for those tables also?
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you.
http://dbtricks.com/?p=62