If you create a new user/schema having trouble importing a database dump file (.dmp) because you are encountering:
OR, simple getting this error when creating tables etc.
Just connect so SQLPLUS or SQL Developer as SYSDBA and run the command:
You can then run import statements or connect as the new user/schema without encountering 0RA-01031.
PRE-REQUISITE: Must run the grant command from SYSDBA
ORA-01031: insufficient privileges
OR, simple getting this error when creating tables etc.
Just connect so SQLPLUS or SQL Developer as SYSDBA and run the command:
GRANT RESOURCE to schema_name;
You can then run import statements or connect as the new user/schema without encountering 0RA-01031.
PRE-REQUISITE: Must run the grant command from SYSDBA
No comments:
Post a Comment