This discussion is archived
3 Replies Latest reply: Apr 4, 2013 5:56 AM by Fran RSS

IMP-00017: following statement failed with ORACLE error 1849

Shaik Newbie
Currently Being Moderated

We have a instance

while doing import i got the issue as:
IMP-00017: following statement failed with ORACLE error 1849:
"job_type=>'STORED_PROCEDURE', job_action=>"
", number_of_arguments=>0,"
"start_date=>'30-AUG-12 +04:00', repeat_interval=> "
"'SYSDATE + 5/1440'"
", end_date=>NULL,"
"job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE, auto_drop=>TRUE,comments="
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



  • Correct Answers - 10 points
  • Helpful Answers - 5 points