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
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