ORA-30041: Cannot grant quota on the tablespace

Error Description:
---------------------------
When I assign quota on the temporary tablespace it throws me an error below.

SQL> ALTER USER INDIA QUOTA 4M ON TEMP;
ALTER USER INDIA QUOTA 4M ON TEMP
*
ERROR at line 1:
ORA-30041: Cannot grant quota on the tablespace

Cause of the Problem:
--------------------------
This is expected behavior in oracle 10.2g. In version 10.2 oracle does not support quota on temporary tablespaces.

If your version is earlier than 10.2g then this is a bug.

Solution of The problem:
--------------------------------
Don't try to assign quota on the temporary tablespaces if your database version is 10.2 as it is expected behavior.

Related Documents

Changing a DBA user to a normal user in oracle

Create user in oracle

Minimum privilege needed to take data pump export

A user can do work in his schema with only Create Session Privilege.

ORA-01536: space quota exceeded for tablespace