ORA-01950: No Privileges On Tablespace 'USERS', Because Index Created By Another User In Different Tablespace

(Doc ID 2316343.1)

Last updated on OCTOBER 29, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms


Receiving Error: ORA-01950: no privileges on tablespace 'USERS', while inserting data, despite of having unlimited quotas on the tablespaces.

select tablespace_name,username, bytes,max_bytes,DROPPED from dba_ts_quotas where username='USER1';

TABLESPACE_NAME USERNAME BYTES MAX_BYTES DRO
------------------------------ ------------------------------ ---------- ---------- ---
DATA1 USER1 0 -1 NO

USERS USER1 0 -1 NO >>>>>>>>>>>>>>>>> Owner has unlimited quota on user tablespace

 

Changes

 The index has been created by different owner in different tablespace. 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms