2019-01-16

Oracle Data Pump Errors: ORA-31626 and ORA-06512 and ORA-31637 and ORA-31632 and ORA-01422


Problem
While implementing a Data Pump Export script, I started getting the following error stack:
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ORA-31626: job does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT", line 1183
ORA-31637: cannot create job CSEXPDP_01 for user SYS
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1176
ORA-31632: master table "SYS.CSEXPDP_01" not found, invalid, or inaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1167
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.KUPV$FT_INT", line 2566
ORA-06512: at "SYS.KUPV$FT_INT", line 2556
ORA-06512: at "SYS.KUPV$FT", line 1092

Cause & Solution
In my case the error was caused, because my script used the same name for the Database Directory and the Data Pump Job.
For example:
It created a DB-Directory like this . . .
CREATE OR REPLACE DIRECTORY tmp_auto_dp_01 AS '...';

. . . and specified a DataPump job name like this:
JOB_NAME=tmp_auto_dp_01
DIRECTORY=tmp_auto_dp_01
SCHEMAS=...
DUMPFILE=...
LOGFILE=...

I hope it helps someone

No comments :

Post a Comment