Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IMP-00017: following statement failed with ORACLE error 1849

ShaikApr 4 2013 — edited Apr 4 2013

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