Veja o que esta acontecendo ao ser executado o "summarization.renewKeyInsert(20," " 20060425, 594079835, 594129834, 20748);"
Aristides. ----- Original Message ----- From: darcio XX To: [email protected] Sent: Thursday, June 19, 2008 5:59 PM Subject: [oracle_br] Erro no import Boa Noite!!! Estou fazento um import imp userid=prod/senha file=exp_mtarf.dum log =exo_mtaref.log ingore=y grnats=n rows=n FULL =y contraints=n buffer=512000 feedback=1000 Esta dando o seguinte erro na log IMP-00017: following statement failed with ORACLE error 1: "BEGIN DBMS_JOB.ISUBMIT(JOB=>40654,WHAT=>'summarization.renewKeyInsert(20," " 20060425, 594079835, 594129834, 20748);',NEXT_DATE=>TO_DATE('4000-01-01:00" ":00:00','YYYY-MM-DD:HH24:MI:SS'),INTERVAL=>'null',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=>40655,WHAT=>'summarization.renewKeyInsert(20," " 20060425, 594129835, 594179834, 20749);',NEXT_DATE=>TO_DATE('4000-01-01:00" ":00:00','YYYY-MM-DD:HH24:MI:SS'),INTERVAL=>'null',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=>40656,WHAT=>'summarization.renewKeyInsert(20," " 20060425, 594179835, 594229834, 20750);',NEXT_DATE=>TO_DATE('4000-01-01:00" ":00:00','YYYY-MM-DD:HH24:MI:SS'),INTERVAL=>'null',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. Alguem tem alguma ideia o q possa ser? desde ja agradeço Darcio Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento! http://br.mail.yahoo.com/ [As partes desta mensagem que não continham texto foram removidas] [As partes desta mensagem que não continham texto foram removidas]
