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 USERSSolution:
ALTER USER "user_name" quota unlimited on "tablespace_name";or
grant unlimited tablespace to "user_name";after that import run successfully.
No comments:
Post a Comment