expdp:ORA-31634: job already exists

使用数据泵进行全备,由于空间不足导致备份失败,清理空间后再次进行备份报如下错误:

With the Partitioning, OLAP and Data Mining options

ORA-31634: job already exists

ORA-31664: unable to construct unique job name when defaulted

解决方法:

1. 在备份时指定一个在dba_datapump_jobs中没有不存在的一个job_name

2. 清理dba_datapump_jobs表

1)查询可以清理的master table并生成SQL

select 'drop table ' || owner_name || '.' || job_name || ';'

from dba_datapump_jobs

where state = 'NOT RUNNING'

2)清理后再次dba_datapump_jobs确认清理成功

SELECT owner_name, job_name, operation, job_mode,

state, attached_sessions

FROM dba_datapump_jobs

ORDER BY 1,2;

若不成功,按下面的方法再次清理

sqlplus oak/oak

exec dbms_datapump.stop_job(dbms_datapump_attach(‘SYS_EXPORT_TABLE_01’,’OAK’));

ITPub博客

expdp:ORA-31634: job already exists