EXPDP IMPDP Failed or terminated with ORA-31633, ORA-06512, ORA-00955

Error Description:
IMPDP failed with following error.
impdp job_name=schemaexp schemas=test dumpfile=exp_test%u.dmp logfile=imp_exp_TEST.log directory=exp_dir

Import: Release - Production on Tue Mar 6 00:26:25 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31633: unable to create master table "SYS.SCHEMAEXP"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1020
ORA-00955: name is already used by an existing object

Solution Description:

This error is because a Job is running or present in the database with the same job name. Use following query to find out the job and terminate it. Then you can rerun the job with same name.

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

OWNER_NAME                     JOB_NAME
------------------------------ ------------------------------
SYS                            SCHEMAEXP

Kill the job using command” drop table <jobname>;”
SQL> drop table SCHEMAEXP;

Table dropped.

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

DBA Tips Data Pump Reference


Post a Comment


dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google