Data Pump Jobs ORA-31626,ORA-31633,ORA-06512 Errors

Buğra PARLAYAN

2 years ago

In today’s article, we will talk about Data Pump Jobs ORA-31626,ORA-31633,ORA-06512 Errors.

Sometimes Oracle DB can cause us problems while exporting.

If you are getting the error as below, follow.

Error message

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bit
Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORA-31626: job does not exist
ORA-31633: unable to create master table “SYS_EXPORT_SCHEMAS_01”
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
ORA-06512: at “SYS.KUPV$FT”, line 863
ORA-00955: name is already used by an existing object

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bit

Production

With the Partitioning, Real Application Clusters, OLAP and Data Mining options

ORA-31626: job does not exist

ORA-31633: unable to create master table “SYS_EXPORT_SCHEMAS_01”

ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95

ORA-06512: at “SYS.KUPV$FT”, line 863

ORA-00955: name is already used by an existing object

Answer

SELECT owner_name, job_name, operation, job_mode, state FROM dba_datapump_jobs;
OWNER_NAME     JOB_NAME              OPERATION   JOB_MODE    STATE
----------     --------------------  ----------  ----------  ------------
SYS            SYS_EXPORT_SCHEMAS_01       EXPORT      FULL        NOTRUNNIG
SQL> drop table SYS.SYS_EXPORT_SCHEMAS_01;
Table dropped.

SELECT owner_name, job_name, operation, job_mode, state FROM dba_datapump_jobs;

OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE

---------- -------------------- ---------- ---------- ------------

SYS SYS_EXPORT_SCHEMAS_01 EXPORT FULL NOTRUNNIG

SQL> drop table SYS.SYS_EXPORT_SCHEMAS_01;

Table dropped.

The issue to be considered here is the “OWNER” part because it is necessary to act on whoever JOB is working on.

After the table is dropped, you can easily continue the process.