Impdp import Materialized View (MV) error: ORA-31685: Object Type materialized_view

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", '2017-07-24 17:21:42 ', 0, 52219, '1970-01-01 12:00:00 ', '', 0, 1950, 0, null, (1," object_id "," object_id ", 8912636, 0), 2097249, 8, ('2017-01-01 12:00:00 ', 4, 0, 0, 1950, 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

Impdp import Materialized View (MV) error: ORA-31685: Object Type materialized_view