Link to home
Start Free TrialLog in
Avatar of pratz09
pratz09Flag for United States of America

asked on

Assigning quota on temporary tablespace in Oracle 10gR2

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:

http://forums.oracle.com/forums/thread.jspa?threadID=372904

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 ?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of johnsone
johnsone
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pratz09

ASKER

Hmm, that makes it pretty clear... That one was for 11g, but its the same case for 10gR2 , given here

http://download.oracle.com/docs/cd/B19306_01/network.102/b14266/admusers.htm#i1006230 

I would give it to you though.

Still I would appreciate if somebody could tell me a work around (o'course tried and tested one) :) .