impdb导入数据出错，救命！！

[feige2000]

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

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

[UPC子夜]

ORA-39082: Object type ALTER_PROCEDURE:"WEBDEV"."UNIONORDER" created with compilation warnings
这表示导入视图时有编译警告，可以忽略
因为在导入视图时，基本表可能还没导过来，所以有警告，等全部导完你再编译一下应该就没问题了

[wffffc]

问题不大,先把无效的对象都重编译一下，再把日志里报错语句重新执行

[心中的彩虹]

[Quote=引用楼主 feige2000 的回复:]
导入数据的时候出现了几个错误，不知道怎么办!

ORA-39082: Object type ALTER_PROCEDURE:"WEBDEV"."UNIONORDER" created with compilation warnings
Processing object type SCHEMA_EXPORT/VIEW/VIEW
ORA-39083: Object type VIEW fa……
[/Quote]

把日志中的对象创建语句重新编译下就可以了 （视图跟触发器）

[Northgale]

问题不大，只要数据表入库了，过程以及其他什么的重新编译一下

[迷失的空间]

同意楼上的。。。

[fingerfox]

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

[aw0910]

impdp...不是db