Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to get rid of this error??
amerar_at_iwc.net wrote:
> Help, please! This error is occuring when I run a SELECT statement
> with a DISTINCT clause in it. Without the DISTINCT clause, it runs
> fine.
>
> ERROR at line 2:
> ORA-03232: unable to allocate an extent of 127 blocks from tablespace
> 3
>
> Tablespace #3 is actually the RBS segment. We are running 8.1.7.
> I've tried setting autoextend, changing the size of the next extent
> parameter......nothing works.......
>
> Ideas anyone?
Then help may be possible.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed Mar 07 2007 - 21:16:26 CST