Google it ....

Showing posts with label Oracle database 12c. Show all posts
Showing posts with label Oracle database 12c. Show all posts

Friday, November 17, 2017

ORA-01950: no privileges on tablespace in Oracle database 12c

Recently I faced error ORA-01950: no privileges on tablespace during import schema in oracle database 12c R2, which was exported from 11g R2.
Cause: In 11g resource role implicitly contains unlimited tablespace privilege, but in 12c resource role doesn't contain unlimited tablespace privilege. Because my user have resource role and in 12c database it doesn't contain tablespace privilege we got :
ORA-01950: no privileges on tablespace USERS
Solution:
ALTER USER "user_name" quota unlimited on "tablespace_name";
or
grant unlimited tablespace to "user_name";
after that import run successfully.