Skip to Main Content

Oracle Database Discussions

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

508936Mar 13 2008 — edited Mar 13 2008
Hi,

I am getting two errors error while importing 10g database dump(OS : RH Linux AS4).
----------------------------------------
IMP-00017: following statement failed with ORACLE error 27456:
"BEGIN "
"dbms_scheduler.create_job('"LOAN_BALANCES_JOB"',"
"program_name=>'"RUN_LOAN_BALANCES"',"
"start_date=>'02-NOV-07 12.00.00.000000 AM +05:30', repeat_interval=> "
"'FREQ=MINUTELY;INTERVAL=1;'"
", end_date=>NULL,"
"job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE, auto_drop=>TRUE,comments="
">"
"'Loan Balances Job'"
");"
"dbms_scheduler.enable('"LOAN_BALANCES_JOB"');"
"COMMIT; END;"
IMP-00003: ORACLE error 27456 encountered
ORA-27456: not all arguments of program "LENDING.RUN_LOAN_BALANCES" have been defined
ORA-06512: at "SYS.DBMS_ISCHED", line 2751
ORA-06512: at "SYS.DBMS_SCHEDULER", line 1794
ORA-06512: at line 10
IMP-00091: Above error occurred on the following function and object: CREATE LOAN_BALANCES_JOB. Remaining PL/SQL blocks for this object will be skipped.
---------------------------------------------------

IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "LENDING"."LEA_DSS_M1" ("DISTRICT"
"","REGIONID","INSPECTORID","MODELID","CATEGORYID","INDUSTRYID") AS "
"select Distinct District,RegionID,InspectorID,"
"ModelID,Categoryid,IndustryID"
"From Lea_dss_m"
IMP-00090: Unexpected DbmsJava error -29546 at step 6667 while creating JAVA RESOURCE "nucleus/core/dboperations/QueryToObject_SJProfile0.ser"
IMP-00017: following statement failed with ORACLE error 29546:
"BEGIN :STATUS := DBMS_JAVA.END_IMPORT(); END;"
IMP-00003: ORACLE error 29546 encountered
ORA-29546: badly formed resource:
. importing GL's objects into GL
-------------------------------------------------------



Please help me to solve this.

Regards,
Mat.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 10 2008
Added on Mar 13 2008
6 comments
710 views