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 -> Re: How to get rid of this error??

Re: How to get rid of this error??

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 07 Mar 2007 19:16:26 -0800
Message-ID: <1173323785.240966@bubbleator.drizzle.com>


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?

  1. Oracle version number
  2. The actual SQL statement triggering the error.
  3. The full error stack copied from SQL*Plus

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.org
Received on Wed Mar 07 2007 - 21:16:26 CST

Original text of this message

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