ORA-01950: no privileges on tablespace ‘PWCSS_DATA’

 ERROR at line 1:

ORA-01950: no privileges on tablespace ‘PWCSS_DATA’

SOLUTION:

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

1. Check the tablespace quota.

select username,tablespace_name,bytes/1024/1024/1024, MAX_BYTES/1024/1024/1024 from dba_ts_quotas where username='PWCSS';

no rows selected.

2. Grant some QUOTA to the user.

SQL> ALTER USER PWCSS QUOTA 100M ON PWCSS_DATA;

User altered.

SQL> GRANT UNLIMITED TABLESPACE TO PWCSS;

GRANT SUCCEEDED.

SQL> select username,tablespace_name,bytes/1024/1024/1024, MAX_BYTES/1024/1024/1024 from dba_ts_quotas where username='PWCSS';

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

SQL> select username,tablespace_name,bytes/1024/1024/1024, MAX_BYTES/1024/1024/1024 from dba_ts_quotas where username='PWCSS';