Impdp error:
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
The reason is that there are materialized views in the exported objects, but the user does not have permission to create materialized views
After the user is authorized, delete the imported data and import it repeatedly to solve the problem
grant create materialized view to user2;