ORA-01950: no privileges on tablespace 'USERS'

This post describes us how to troubleshoot "ORA-01950" issue.

Issue:

SQL> show user

USER is "ADAM"

SQL> insert into source values(100,'VIJAY','BANGALORE');

insert into source values(100,'VIJAY','BANGALORE')

            *

ERROR at line 1:

ORA-01950: no privileges on tablespace 'USERS'

Solution:

User ADAM does have privileges on USERS tablespace. Need to give grant "QUOTA UNLIMITED" to user ADAM to overcome this issue.

Connect as sys to database and give the concern grant.

SQL> conn sys as sysdba

Enter password: 

Connected.

SQL> show user

USER is "SYS"

SQL> alter user adam quota unlimited on users;

User altered.

Validation:

SQL> conn adam/welcome

Connected.

SQL> insert into source values(100,'VIJAY','BANGALORE');

1 row created.

SQL> commit;

Commit complete.

Thanks for your patience to view this post...........