1 使用EXPDP导出报错：
[oracle@host3 ~]$ expdp \'/ as sysdba\' JOB_NAME=xsc1 directory=JCSJ_PUMP_22_22 tables=userA.c_tableA dumpfile=c_tableA1009.dmp logfile=c_tableA1009.log CLUSTER=N
Export: Release 11.2.0.4.0 - Production on Sun Oct 9 15:13:18 2022
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.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.XSC1"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1038
ORA-00955: name is already used by an existing object
2 在Oracle官网查看相关文档，同如下文档一致（ DataPump Export Or Import Fails With Errors ORA-31633 ORA-6512 ORA-955 (Doc ID 556425.1)）
3 按照如上文档，针对JOB名称及相关SQl做相关修改。
3.1 查看数据导出导入是否有相同的名称，及相关JOB运行的状态，发现为没有运行
set linesize 300
col OPERATION for a10
col TTACHED_SESSIONS for a10
col JOB_MODE for a10
col STATE for a12
select owner_name, job_name, operation, job_mode,
state, attached_sessions
from dba_datapump_jobs
where job_name like 'XSC%'
order by 1, 2;
OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE ATTACHED_SESSIONS
------------------------------ ------------------------------ ---------- ---------- ------------ -----------------
SYS XSC1 IMPORT FULL NOT RUNNING 0
3.2 使用如下语句查看数据库对象的名称。
col OWNER.OBJECT for a20
select o.status, o.object_id, o.object_type,
o.owner||'.'||object_name "OWNER.OBJECT"
from dba_objects o, dba_datapump_jobs j
where o.owner=j.owner_name and
o.object_name=j.job_name and
j.job_name like 'XSC%'
order by 4, 2;
STATUS OBJECT_ID OBJECT_TYPE OWNER.OBJECT
------- ---------- ------------------- --------------------
VALID 4202097 TABLE SYS.XSC1
3.3 使用如下语句可以查看以前执行的JOB时间、报错原因及相关的执行命令。
3.4 删除相关表
SYS@host3 >drop table SYS.XSC1;
Table dropped.
4 再次执行，一切OK。
[oracle@host3 ~]$ expdp \'/ as sysdba\' JOB_NAME=xsc1 directory=JCSJ_PUMP_22_22 tables=userA.c_tableA dumpfile=c_tableA1009.dmp logfile=c_tableA1009.log CLUSTER=N
Export: Release 11.2.0.4.0 - Production on Sun Oct 9 15:14:36 2022
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Starting "SYS"."XSC1": "/******** AS SYSDBA" JOB_NAME=xsc1 directory=JCSJ_PUMP_22_22 tables=userA.c_tableA dumpfile=c_tableA1009.dmp logfile=c_tableA1009.log CLUSTER=N
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 4.197 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "userA"."c_tableA" 3.566 GB 52201647 rows
Master table "SYS"."XSC1" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.XSC1 is:
/goldengate/ftp/yx/c_tableA1009.dmp
Job "SYS"."XSC1" successfully completed at Sun Oct 9 15:46:14 2022 elapsed 0 00:31:33