日期:2014-05-16  浏览次数:21062 次

impdb导入数据出错,救命!!
导入数据的时候出现了几个错误,不知道怎么办!

ORA-39082: Object type ALTER_PROCEDURE:"WEBDEV"."UNIONORDER" created with compilation warnings
Processing object type SCHEMA_EXPORT/VIEW/VIEW
ORA-39083: Object type VIEW failed to create with error:
ORA-04045: errors during recompilation/revalidation of WEBDEV.ORDR_MAIN
ORA-00980: synonym translation is no longer valid
Failing sql is:
CREATE FORCE VIEW "WEBDEV"."REPORT" ("ORDRID", "PROD_SEQ", "PRODID", "PRODNAME", "PRODUCT_TYPE", "PROMOTIONID", "LGORT", "PROD_CNT", "PROD_PRICE", "ORIGINAL_PRICE", "WEIGHT", "COST", "BONUS_UNIT", "IF_STOCK", "CATEGORY_LEVEL3_ID", "CATEGORY_LEVEL2_ID", "CATEGORY_LEVEL1_ID", "CATEGORY_LEVEL0_ID", "DAYTIME") AS (se
ORA-39083: Object type VIEW failed to create with error:
ORA-04045: errors during recompilation/revalidation of WEBDEV.ORDR_MAIN
ORA-00980: synonym translation is no longer valid
Failing sql is:
CREATE FORCE VIEW "WEBDEV"."REPORT_VIEW" ("ORDRID", "PROD_SEQ", "PRODID", "PRODNAME", "PRODUCT_TYPE", "PROMOTIONID", "LGORT", "PROD_CNT", "PROD_PRICE", "ORIGINAL_PRICE", "WEIGHT", "COST", "BONUS_UNIT", "IF_STOCK", "CATEGORY_LEVEL1_ID", "CATEGORY_LEVEL2_ID", "CATEGORY_LEVEL3_ID", "CATEGORY_LEVEL0_ID", "DAYTIME", "
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
ORA-39083: Object type TRIGGER failed to create with error:
ORA-04045: errors during recompilation/revalidation of WEBDEV.ORDR_PROD
ORA-00980: synonym translation is no longer valid
Failing sql is:
CREATE TRIGGER "WEBDEV"."ORDR_PROD_SEQ_INC" BEFORE INSERT
ON ORDR_PROD REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW
 WHEN (
NEW.prod_seq IS NULL
  ) begin
select ORDR_PROD_SEQ.nextval into :NEW.prod_seq from dual;
end;
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "WEBDEV"."SYS_IMPORT_SCHEMA_01" completed with 5 error(s) at 18:36:33


------解决方案--------------------
你导入的时候,这些View依赖的对象导入了吗?如果导入了,那么重新编译一下能解决问题,否则你得把这些依赖的对象也倒进来。这些对象可能存在别的Schema下。