ORA-31626 ORA-31633 ORA-06512 ORA-04045 ORA-01031

while I was doing import using impdp utility , I was getting below errors.

ORA-31626: job does not exist
ORA-31633: unable to create master table “BDSPRD.SYS_IMPORT_TABLE_05”
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
ORA-06512: at “SYS.KUPV$FT”, line 1020
ORA-04045: errors during recompilation/revalidation of SRTBDS.AUTO_GRANT_TRIG
ORA-01031: insufficient privileges

Solution :

This error is because a Job is not running and present in the database. Use following query to find out the job and terminate it. remove the table and run the import again.

SQL> select OWNER_NAME, JOB_NAME, JOB_MODE, OPERATION from dba_datapump_jobs;

OWNER_NAME                     JOB_NAME
—————————— ——————————
JOB_MODE                       OPERATION
—————————— ——————————
PRDEODBOD                      SYS_EXPORT_TABLE_01
TABLE                          EXPORT

Delete the table

drop table PRDEODBOD.SYS_EXPORT_TABLE_01;

start the impdp again

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s