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:45The 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;
Read More:
- Error: invalid permission for adding an object to repository database
- How can Oracle query tables of other users without adding a table user name
- Datagrip import & export table structure and data
- What is the schema in the database?
- ArcGIS desktop experience. Similar to: error 000732 output Geodatabase
- [MySQL] error 1396 (HY000): Operation create user failed for ‘MySQL’ @’localhost ‘
- Viewing crontab log of timed tasks in Linux
- Error 1396 (HY000): Operation create user failed for ‘xxx’ @’xxx ‘
- mysql ERROR:1396
- [PostgreSQL tutorial] · PostgreSQL error prompt: “error 42501” or “permission denied”
- The python version output from the command line is inconsistent with the python version in the current CONDA environment
- ERROR 1406 (22001): Data Too Long, field len 30, data len 48
- Step on the pit — error reported by sqoop tool.ExportTool : Error during export
- express nodejs Failed to lookup view error in views directory (How to Fix)
- “Hive metadata problem” hive.metastore.HiveMetaException : Failed to get schema version.
- The element “extra pin The solution of “in normal of part” warning
- Express error: Failed to lookup view “error” in views directory processing
- Export and import method of MySQL under Linux
- How to compare the equality of structures in golang
- Android avoids memory leak: reasonable use of getcontext() and getapplication ()