Ora-30041 While Alter User X Quota Unlimited On Temp Ora-30041

(Doc ID 331657.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

Trying to create or alter an user so as to grant unlimited quota on a Temp tablespace to that user and getting ora-30041.

create user xyz  identified by abc default tablespace users quota unlimited on users temporary tablespace temp quota unlimited on temp;

*
ERROR at line 1:
ORA-30041: Cannot grant quota on the tablespace

or

alter user xyz quota unlimited on temp ;

*
ERROR at line 1:
ORA-30041: Cannot grant quota on the 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