PROBLEM:

Granting tablespace quota to a user is failing with ORA-30041.

SQL> alter user dba_raj quota unlimited on TEMP ;
alter user dba_raj quota unlimited on TEMP
*
ERROR at line 1:
ORA-30041: Cannot grant quota on the tablespace


SQL> alter user dba_raj quota unlimited on undotbs1;
alter user dba_raj quota unlimited on undotbs1
*
ERROR at line 1:
ORA-30041: Cannot grant quota on the tablespace

SOLUTION:

We can’t grant quota on a UNDO or TEMPORARY tablespace. Quota can be granted only to PERMANENT tablespace.

SQL> select tablespace_name,contents from dba_Tablespaces;

TABLESPACE_NAME                CONTENTS
------------------------------ ---------
SYSAUX                         PERMANENT
SYSTEM                         PERMANENT
TEMP                           TEMPORARY  --- > 
TEST                           PERMANENT
TEST_2                         PERMANENT
TS_CRM_EXTCH                   PERMANENT
TS_GGATE                       PERMANENT
USERS                          PERMANENT
UNDOTBS1                       UNDO  ----- -- > 

Now grant quota from a PERMANENT tablespacce

alter user dba_raj quota unlimited on TS_GGATE;

User altered.