Friday, 23 January 2015

ORA-01950 No Privileges On Tablespace USERS


Data cannot be inserted if  there is no quota on tablespace.

Solution 1:
SQL-> Alter user <user> quota unlimited on <tablespace_name>;
Solution 2
SQL-> Alter user <user> quota 100M on  <tablespace_name>;

No comments:

Post a Comment