Sunday 2 November 2014

SQL Error: ORA-01950: no privileges on tablespace 'USERS'

As salamo alaikum wa rahmatullah

It is generated while i am trying to insert the data in the newly created table in newly created schema.

SQL Error: ORA-01950: no privileges on tablespace 'USERS'



01950. 00000 -  "no privileges on tablespace '%s'"

*Cause:    User does not have privileges to allocate an extent in the
           specified tablespace.
*Action:   Grant the user the appropriate system privileges or grant the user
           space resource on the tablespace.


answer - alter user c##prac Quota 100M ON SYSTEM;

Grant unlimited Tablespace to c##prac;


now row has been inserted.


Thanking you to visit 
--
Mohammad Shahnawaz
Passion for Oracle