ORA-01950: no privileges on tablespace USERS
Oracle SQL Error: ORA-01950: no privileges on tablespace ‘USERS’
Cause:
User does not have privileges to allocate an extent in the specified tablespace.
Solution:
Grant the user the appropriate system privileges or grant the user space resource on the tablespace.
Example:
Insert into DEPARTMENTS (DEP_ID,DEP_NAME) values ('1','aaa');
Output:
SQL Error: ORA-01950: no privileges on tablespace ‘USERS’
Correct
Connect as SYSDBA and execute the next grant command:
GRANT UNLIMITED TABLESPACE TO test;
Output:
Grant succeeded.
Connect as TEST and execute the insert command:
Insert into DEPARTMENTS (DEP_ID,DEP_NAME) values ('1','aaa');
Output:
1 row inserted.