ORA-01950: no privileges on tablespace ‘USERS’

ORA-01950: no privileges on tablespace ‘USERS’

While inserting data into the table we are getting the following error:

SQL> insert into testing values (1,'RAM');
insert into testing values (1,'RAM')
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'USERS'

ORA Error:
Error: ORA-01950: no privileges on tablespace “string”
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.

Solution:
You need to assign the permission to the user on the tablespace mentioned in error:

1. Login with sysdba user:

SQLPLUS / as sysdba

2. Assign the Privileges on the table-space.
I am using TEST user.

SQL> grant unlimited tablespace to test;
Grant succeeded.

3. You can also assigned with ALTER user command.

ALTER USER username QUOTA 500M ON tablespace_name

ALTER USER username QUOTA UNLIMITED ON tablespace_name;

4. After assign then verify with insert query and query to DBA_TS_QUOTAS view.

-- insert
SQL> insert into testing values (1,'RAM');
1 row created.
SQL> insert into testing values (2,'SHAM');
1 row created.

-- View
select (bytes)/1024/1024,MAX_BYTES/1024/1024 from dba_ts_quotas where username='TEST';

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.