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
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

Legend

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