This discussion is archived
12 Replies Latest reply: Nov 20, 2012 4:58 AM by rafael ceolim RSS

ORA-01536 Space Quota with resource and unlimited tablespace privilege

rafael ceolim Newbie
Currently Being Moderated
Good morning.
I've got the following error ORA-01536: space quota exceeded for tablespace, but my owner has the following grants:
- RESOURCE
- UNLIMITED TABLESPACE
The tablespace transaction has allocated 150GB and when it's about 90% of space used the error occurs, but we have auto extend in all tablespaces.

My environment:
Oracle Database 10.2.0.2
RAC - ASM
Server Red Hat release 4

Best Regards,
Rafael Ceolim

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points