Thursday, May 1, 2014

UDE-00008: operation generated ORACLE error 31626

This one is interesting and do not panic by just seeing these messages in your EXPDP but check the log file and see if it says job successfully completed or not...

UDE-00008: operation generated ORACLE error 31626
ORA-31626: job does not exist
ORA-39086: cannot retrieve job information
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2772
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3886
ORA-06512: at line 1

I was running expdp with nohup in background by appending nohup info into out file and was checking the out file and noticed these errors and felt that the export job really had an issue.

Opened the log file which is from the parameters settings and the log file says its completed successfully!!!

Oracle Doc ID:549781.1 states:
This issue has been discussed in Bug 5969934 EXPDP CLIENT GETS UDE-00008 ORA-31626 WHILE THE SERVER SIDE EXPORT IS OK

No comments:

Post a Comment