Impdp import Materialized View (mv) error: ORA-31685: Object type MATERIALIZED_VIEW, impdpora-31685
This article is the original article, reprint please indicate the source: http://blog.csdn.net/msdnchina/article/details/38782657
Impdp import Materialized View (mv) error: ORA-31685: Object type MATERIALIZED_VIEW
Db version 10.2.0.4
The impdp command is
Impdp sys/as dumpfile = scott. dmp logfile = scott_imp_no_remap.log
Import error:
Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEWORA-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
Solution:
1. First create scott user: create user scott identified by aaaaaa;
2. grant scott the user the permission to create a music video: grant create MATERIALIZED_VIEW to scott;
3. Run impdp again: impdp sys/as dumpfile = scott. dmp logfile = scott_imp_no_remap.log