ORA-39086: cannot retrieve job information

During EXPDP process, on Command prompt following error was generated:

UDE-31626: operation generated ORACLE error 31626
ORA-31626: job does not exist
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4750
ORA-06512: at "SYS.KUPV$FT_INT", line 2082
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT_INT", line 2062
ORA-39086: cannot retrieve job information
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT_INT", line 2055
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2266
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4499
ORA-06512: at "SYS.DBMS_DATAPUMP", line 6104
ORA-06512: at line 1

Solution:

On checking the log file, it says it was completed successfully.

W-1 Master table "HR"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for HR.SYS_EXPORT_SCHEMA_01 is:
  C:\backup\HR.DMP
Job "HR"."SYS_EXPORT_SCHEMA_01" successfully completed at Sun Jan 23 10:42:47 2022 elapsed 0 00:01:01

On internet search, many blogs say it is a bug and safely ignore this error.

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply