PROBLEM:

While creating a table using CTAS, got an error, ORA-01950: no privileges on tablespace ‘USERS’.

SQL> create table DBACLASS.EMPLO as select * from user_objects;
create table EMPLO as select * from user_objects
*
ERROR at line 1:
ORA-01950: no privileges on tablespace ‘USERS’

SOLUTION:

This error comes, when the user the user doesn’t have tablespace quota.

1. Check the tablespace quota.

2. Grant some QUOTA to the user.

Now we user DBACLASS has 5G quota on tablespace USERS. Let’s run the same create statement.

It worked. Now, check how much quota has been used.