We have recently done Oracle 10gR2 installation, and we were trying to assign quota to users on temp tablespace. OEM isn't working out and queries are throwing error: ORA-30041: Cannot grant quota on the table space.
I have read through this link:
in which contributors are saying that ability to grant quota on temp tablespace was a bug which was fixed in Oracle 10g. That doesn't make a whole lot sense to me. Because in older versions of Oracle the temporary tablespace was actually a "normal" tablespace just full of sort segments.
Now, Oracle has distinguished "temporary" as a different, unique type of tablespace ? Is there any work around ? Anybody aware of any official statement from Oracle regarding this ?