import error
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.