impdp时报错:
Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW
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 failed due to insufficient privileges. Failing sql is:
Job "SYS"."SYS_IMPORT_FULL_01" completed with 9 error(s) at 14:37:45
原因是导出的对象中有物化视图,但是用户没有创建物化视图的权限
对用户进行授权后,删除已导入的数据,重复导入,解决该问题
grant create materialized view to user2;