ORA-01950: no privileges on tablespace 'SNOOPY'

SQL> create table t2(

  2  col1 char);

create table t2(

*

ERROR at line 1:

ORA-01950: no privileges on tablespace 'SNOOPY'

 

 

SQL> conn sys/lubinsu as sysdba

Connected.

SQL> alter user lubinsu quota unlimited on snoopy;

 

User altered.

 

SQL> conn lubinsu/lubinsu

Connected.

 

SQL> create table t1(

  2  col1 char);

 

Table created.