SQL> create table test ( id number );
create table test ( id number )
*
ERROR at line 1:
ORA-01950: no privileges on tablespace ‘USERS’

SOLUTION

SQL> select TABLESPACE_NAME,USERNAME,MAX_BYTES,BYTES from dba_ts_quotas where USERNAME='SCOTT';

no rows selected

SQL> alter user scott default tablespace users quota 10m on users;



User altered.

SQL>  create table test ( id number );



Table created.

SQL> select TABLESPACE_NAME,USERNAME,MAX_BYTES,BYTES from dba_ts_quotas where USERNAME='SCOTT';



TABLESPACE_NAME      USERNAME       MAX_BYTES      BYTES

-------------------- ------------- ---------- ----------

USERS                SCOTT      10485760      65536