advertisements
_____________________________________________________________________________________________________________________
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 11.2.0.2.0 - 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 11.2.0.2.0 - 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
------------------------------ ------------------------------
JOB_MODE
--------------------------------------------------------------------------------
OPERATION
--------------------------------------------------------------------------------
SYS SCHEMAEXP
SCHEMA
IMPORT
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;
no rows selected
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment