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!

Import terminated unsuccessfully

Raja MarmamApr 2 2009 — edited Apr 2 2009

Hi,

I am getting below error messages when I import the dump file.
Could you please tell me the cause for these errors.

IMP-00017: following statement failed with ORACLE error 942:
"CREATE TRIGGER "USER1"."HI_DEALER_CUSTOMER_INS_BEF" BEFORE INSERT ON OP"
"S$SQLTIME.HI_DEALER_CUSTOMER REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW"
" "
"BEGIN"
" update sch_shipping_log set ssl_sold_dt=:new.DLC_PURCHASE_DATE"
" where ssl_sold_dt is null"
" and ssl_serial=(select smh_lot_serial from sch_mrp_hdr where smh_id=:n"
"ew.dlc_mrp_id);"
"END;"
""
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
"CREATE TRIGGER "USER1"."SD_DEALER_CUSTOMER_INS_BEF""
" BEFORE INSERT ON ops$sqltime.sd_dealer_customer"
" REFERENCING new AS new old AS old"
" FOR EACH ROW"
""
"BEGIN"
" UPDATE sch_shipping_log"
" SET ssl_sold_dt = :new.sdc_purchase_date"
" WHERE ssl_sold_dt IS NULL AND"
" ssl_serial = (SELECT smh_lot_serial"
" FROM sch_mrp_hdr"
" WHERE smh_id = :new.sdc_smh_id);"
"END;"

-----------------------------------------------------------------------------------------------
At the end I have received these error messages
-----------------------------------------------------------------------------------------------

IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
ORA-06512: at "SYS.DBMS_IREFRESH", line 85
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_REFRESH", line 83
ORA-06512: at "SYS.DBMS_REFRESH", line 62
ORA-06512: at line 1
IMP-00000: Import terminated unsuccessfully

Thanks,
Raja