My Oracle Support Banner

ORA-01950: No Privileges On Tablespace 'USERS', Because Index Created By Another User In Different Tablespace (Doc ID 2316343.1)

Last updated on AUGUST 04, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.