红帽5企业版+oracle10g数据迁移AIX5.3+oracle10g故障
环境:serverA: redhat5企业版+oracle10g
serverB:AIX5.3+oracle10g
前几日在lzj65166兄弟的帮助下在5.3中安装了oracle,即刻准备从服务器A中将oracle的数据迁移至服务器B中的oracle中,但在imp命令导入serverA中的数据的过程中报错。
注:oracle字符集二服务器均选择为UTF-8,应该不是字符集造成的。
报错结果:
IMP-00017: following statement failed with ORACLE error 1:
"BEGIN DBMS_JOB.ISUBMIT(JOB=>21,WHAT=>'SP_FOUNDER_CMS_SYNC_TEXT;',NEXT_DAT"
"E=>TO_DATE('2009-03-20:06:00:28','YYYY-MM-DD:HH24:MI:SS'),INTERVAL=>'SYSDAT"
"E + (1/24/4)',NO_PARSE=>TRUE); END;"
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
ORA-06512: at "SYS.DBMS_JOB", line 97
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1:
"BEGIN DBMS_JOB.ISUBMIT(JOB=>22,WHAT=>'SP_FOUNDER_CMS_OPTIM_TEXT;',NEXT_DA"
"TE=>TO_DATE('2009-03-20:09:06:14','YYYY-MM-DD:HH24:MI:SS'),INTERVAL=>'SYSDA"
"TE + 1',NO_PARSE=>TRUE); END;"
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
ORA-06512: at "SYS.DBMS_JOB", line 97
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 1:
"BEGIN DBMS_JOB.ISUBMIT(JOB=>23,WHAT=>'SP_WORKSTAT(TO_CHAR(SYSDATE - 1,''Y"
"YYY-MM-DD''));',NEXT_DATE=>TO_DATE('2009-03-20:09:06:14','YYYY-MM-DD:HH24:M"
"I:SS'),INTERVAL=>'SYSDATE+1',NO_PARSE=>TRUE); END;"
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
ORA-06512: at "SYS.DBMS_JOB", line 97
ORA-06512: at line 1
Import terminated successfully with warnings.
收起