程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> Oracle數據庫 >> Oracle教程 >> impdp導入物化視圖(mv)時報錯:ORA-31685:ObjecttypeMATERIALIZED_VIEW

impdp導入物化視圖(mv)時報錯:ORA-31685:ObjecttypeMATERIALIZED_VIEW

編輯:Oracle教程

impdp導入物化視圖(mv)時報錯:ORA-31685:ObjecttypeMATERIALIZED_VIEW


本文為原創文章,轉載請注明出處: http://blog.csdn.net/msdnchina/article/details/38782657

impdp 導入物化視圖(mv)時報錯 :ORA-31685: Object type MATERIALIZED_VIEW

db 版本為10.2.0.4
impdp 命令為
impdp sys/as dumpfile=scott.dmp logfile=scott_imp_no_remap.log

導入的報錯為:
Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW
ORA-31685: Object type MATERIALIZED_VIEW:"SCOTT"."LEITEST0719" failed due to insufficient privileges. Failing sql is:
CREATE MATERIALIZED VIEW "SCOTT"."LEITEST0719" USING ("LEITEST0719", (8, 'FS', 1, 0, 0, "SCOTT", "LEITEST0719", '2013-07-24 17:21:42', 0, 52219, '1950-01-01 12:00:00', '', 0, 8912636, 0, NULL, (1, "OBJECT_ID", "OBJECT_ID", 0, 321, 0)), 2097249, 8, ('1950-01-01 12:00:00', 4, 0, 0, 8912636, 0, 0, 1, NULL, NULL), '@BBB') REFRESH FAST WITH PRIMARY KEY AS SELECT "LEITEST0719"."OWNER" "OWNER","
Processing object type SCHEMA_EXPORT/TABLE/MATERIALIZED_VIEW_LOG
處理方法為:

1.首先建立scott用戶:create user scott identified by aaaaaa;
2.賦予scott用戶建立mv的權限:grant create MATERIALIZED_VIEW to scott;
3.重新執行impdp即可:impdp sys/as dumpfile=scott.dmp logfile=scott_imp_no_remap.log

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved