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]

Responder a