Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to get rid of this error??

How to get rid of this error??

From: <amerar_at_iwc.net>
Date: 7 Mar 2007 07:22:51 -0800
Message-ID: <1173280971.418418.206530@s48g2000cws.googlegroups.com> 






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?
Received on Wed Mar 07 2007 - 09:22:51 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US