ORA-01950: no privileges in tablespace 'USERS'

Question

I get this error:

ORA-01950: no privileges in the USERS tablespace

I have a default tablespace and I can create tables, however they do not appear on the objects tab in Toad. I cannot insert anything into the tables being created.

Answer 1

You cannot insert data because you have a quota of 0 in the table space. To fix this, run

ALTER USER <user> quota unlimited on <tablespace name>; 

or

 ALTER USER <user> quota 100M on <tablespace name>; 

as a DBA user (depending on how much space you need / want to provide).