My Oracle Support Banner

EXPDP And IMPDP - UDE-31626 And ORA-31626 (job Does Not Exist) At End Of Job, While No Errors In The Logfile (Doc ID 1970322.1)

Last updated on SEPTEMBER 14, 2024

Applies to:

Oracle Database - Standard Edition - Version 10.1.0.2 to 12.1.0.2 [Release 10.1 to 12.1]
Enterprise Manager for Oracle Database - Version 10.1.0.2 to 12.1.0.7.0 [Release 10.1 to 12.1]
Oracle Database - Personal Edition - Version 10.1.0.2 to 12.1.0.2 [Release 10.1 to 12.1]
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 12.1.0.2 [Release 10.1 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

1.You have an Operating System script file or CRON job that runs an Export DataPump (expdp) periodically. Occasionally the script output file shows the following errors at the end of the file:

...
. . exported "<SCHEMA_NAME>"."<TABLE_NAME>"                 0 KB       0 rows

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

or:

...
. . exported "<SCHEMA_NAME>"."<TABLE_NAME>"                 0 KB       0 rows

Execute Failed: ORA-31626: job does not exist
ORA-39086: cannot retrieve job information
ORA-6512: at "SYS.DBMS_DATAPUMP", line 2772
ORA-6512: at "SYS.DBMS_DATAPUMP", line 3886
ORA-6512: at line 27 (DBD ERROR: OCIStmtExecute)

or:

...
. . exported "<SCHEMA_NAME>"."<TABLE_NAME>"                 0 KB       0 rows

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 2745
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3712
ORA-06512: at line 1

or incidently also for an Import Data Pump job (impdp):

...
. . imported "<SCHEMA_NAME>"."<TABLE_NAME>"                 0 KB       0 rows

UDI-31626: operation generated ORACLE error 31626
ORA-31626: job does not exist
ORA-39086: cannot retrieve job information
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2862
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4052
ORA-06512: at line 1

2. The logfile of the DataPump job however, does not show any errors.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.