ora-31685 error when using impdp
742908Jan 18 2010 — edited Jan 19 2010Both the source and target database's version are 11g r1(11.1.0.6.0).The EXPDP finished well without error,But ORA-31685 error happened when IMPDP,error message as follow:
ORA-31685: Object type VIEW:"YDSJ"."MY_TAB_COLS" failed due to insufficient privileges. Failing sql is:
CREATE FORCE VIEW "YDSJ"."MY_TAB_COLS" ("COLUMN_NAME", "TABLE_NAME") AS select column_name,table_name from all_tab_cols
ORA-31685: Object type failed due to insufficient privileges. Failing sql is:
ORA-31685: Object type failed due to insufficient privileges. Failing sql is:
ORA-31685: Object type VIEW:"YDSJ"."YD_DAB121A_VIEW" failed due to insufficient privileges. Failing sql is:
CREATE FORCE VIEW "YDSJ"."YD_DAB121A_VIEW" ("LBDM", "LBMC", "XH", "ND", "ZHDYDM", "BJDYDM", "DYDM", "JJBZ") AS SELECT B."LBDM",B."LBMC",A."XH",A."ND",A."ZHDYDM",A."BJDYDM",A."DYDM",A."JJBZ" FROM YD_DAB121A A,YD_FLE9_VIEW B where JJBZ='0'
ORA-31685: Object type VIEW:"YDSJ"."YD_DAB121_VIEW" failed due to insufficient privileges. Failing sql is:
CREATE FORCE VIEW "YDSJ"."YD_DAB121_VIEW" ("LBDM", "LBMC", "YQTDM", "ZHDYDM", "DYDM", "ND", "DYBZ", "XZBZ", "SCBZ") AS SELECT B."LBDM",B."LBMC",A."YQTDM",A."ZHDYDM",A."DYDM",A."ND",A."DYBZ",A."XZBZ",A."SCBZ" FROM YD_DAB121 A,YD_FLE9_VIEW B
I can't find any information in oralce document.
Who can help me ?
Tel me why and how to resolve.