ORA-00001 Unique Constraint SYS.I_JOB_JOB Violated

链接：http://www.xifenfei.com/2999.html

IMPDP导入数据发现ORA-00001 Unique Constraint SYS.I_JOB_JOB Violated错误

			
									ORA-39083: Object type JOB failed to create with error:
								
									ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
								
									Failing sql is:
								
									 BEGIN DBMS_JOB.ISUBMIT( JOB=> 63, NEXT_DATE=> TO_DATE('2012-04-27 00:00:00', 
								
									'YYYY-MM-DD:HH24:MI:SS'), INTERVAL=> 'TRUNC(SYSDATE+1)', WHAT=> 'GBEAS1.UPDATE_EMP_INFO;', 
								
									NO_PARSE=> TRUE); END;   
								
									Job "GBEAS3"."SYS_IMPORT_FULL_01" completed with 8 error(s) at 16:05:58

错误原因(该job=63已经存在数据库中)

			
									select job, what from   dba_jobs where job=63; 
								
									JOB     WHAT 
								
									-----   -------- 
								
									63      proc_xifenfei

注意:如果该job正在运行,可能需要查询DBA_JOBS_RUNNING

解决办法

			
									1.手工创建job,指定一个不存在的job 号
								
									declare
								
									  m_job number;
								
									begin
								
									  select max (job) + 1 
								
									  into   m_job 
								
									  from   dba_jobs; 
								
									BEGIN DBMS_JOB.ISUBMIT( JOB=> m_job, NEXT_DATE=> TO_DATE('2012-04-27 00:00:00', 
								
									'YYYY-MM-DD:HH24:MI:SS'), INTERVAL=> 'TRUNC(SYSDATE+1)', WHAT=> 'GBEAS1.UPDATE_EMP_INFO;', 
								
									NO_PARSE=> TRUE); END; 
								
									end;
								
									/
								
									2.删除原存在job
								
									exec dbms_job.remove (63);