SQL> create table mith( n number primary key, l varchar2(60));
create table mith( n number primary key, l varchar2(60))
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'USERS'
Whenever a new user is created it requires certain previlages like connect, create any table, view etc along with grant on table space. To get rid of this error you can use the following sq,
1) GRANT UNLIMITED TABLESPACE TO MITH;
OR
2) ALTER USER MITH QUOTA 50M ON USERS;
create table mith( n number primary key, l varchar2(60))
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'USERS'
Whenever a new user is created it requires certain previlages like connect, create any table, view etc along with grant on table space. To get rid of this error you can use the following sq,
1) GRANT UNLIMITED TABLESPACE TO MITH;
OR
2) ALTER USER MITH QUOTA 50M ON USERS;
Comments