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:
- [MySQL] error 1396 (HY000): Operation create user failed for ‘MySQL’ @’localhost ‘
- Error 1396 (HY000): Operation create user failed for ‘xxx’ @’xxx ‘
- mysql ERROR:1396
- express nodejs Failed to lookup view error in views directory (How to Fix)
- Express error: Failed to lookup view “error” in views directory processing
- The element “extra pin The solution of “in normal of part” warning
- R language error messages and related solutions
- Some mistakes and solutions in Django
- Android avoids memory leak: reasonable use of getcontext() and getapplication ()
- Struts 2 encapsulates form data into list and map sets
- Solution to MySQL Error 1130 problem
- ArcGIS desktop experience. Similar to: error 000732 output Geodatabase
- Some projects cannot be imported because they already exist in the workspace
- How to compare the equality of structures in golang
- The Ethereum private chain is built, and the block information cannot be synchronized. The error is resolved: Node data write error err=”state node failed with all peers(1 tries, 1 peers)
- Error: invalid permission for adding an object to repository database
- Install sql2012 prompt setup account privileges failed solution
- T omcat:removeGeneratedFiles Failed to delete the generated java file solution
- MySQL password setting error message: error 1054 (42s22): unknown column ‘password’ in ‘field list’
- Step on the pit — error reported by sqoop tool.ExportTool : Error during export