3 Replies Latest reply: Apr 4, 2013 7:56 AM by Fran RSS

    IMP-00017: following statement failed with ORACLE error 1849

    Shaik
      Hi

      We have a instance 11.1.0.7

      while doing import i got the issue as:
      IMP-00017: following statement failed with ORACLE error 1849:
      "BEGIN "
      "dbms_scheduler.create_job('"MAXIMOTSSYNC"',"
      "job_type=>'STORED_PROCEDURE', job_action=>"
      "'maximo_ts_job'"
      ", number_of_arguments=>0,"
      "start_date=>'30-AUG-12 15.12.04.000000 +04:00', repeat_interval=> "
      "'SYSDATE + 5/1440'"
      ", end_date=>NULL,"
      "job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE, auto_drop=>TRUE,comments="
      ">"
      "NULL"
      ");"
      "dbms_scheduler.enable('"MAXIMOTSSYNC"');"
      "COMMIT; END;"
      IMP-00003: ORACLE error 1849 encountered
      ORA-01849: hour must be between 1 and 12
      ORA-06512: at line 2
      IMP-00091: Above error occurred on the following function and object: CREATE MAXIMOTSSYNC. Remaining PL/SQL blocks for this object will be skipped.
      Import terminated successfully with warnings.



      My imp command is:
      imp system/manager file=schema.DMP log=schema.log fromuser=max touser=max

      Please suggest on this


      Thanks
      Shaik