I was connected as sysdba and when I tried to assign quota on temporary tablespace I got an error:
SQL> ALTER USER r_nahar QUOTA UNLIMITED ON TEMP;
ALTER USER r_nahar
*
ERROR at line 1:
ORA-30041: Cannot grant quota on the tablespace
Why this error:
It is 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:
Don't try to assign quota on the temporary tablespaces if your database version is 10.2 as it is expected behavior.
