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

Home -> Community -> Usenet -> c.d.o.tools -> Re: ora -03232

Re: ora -03232

From: Stephen Bell <stephen.bell_at_cgi.ca>
Date: Wed, 20 Jun 2001 12:29:38 -0400
Message-ID: <3B30CF71.BD920B1D@cgi.ca>

Hi,
It appears your tablespace3 is full to the point that it can't find 14 contiguous blocks..
You can use ALTER TABLESPACE to either increase the size of the associated datafile or add a new datafile.....that should do it..

Steve

Leonid wrote:

> Hi,
> I have identical schemas in two envs (oracle 8i and oracle 9i).
> View which extracts data from 5 tables
> In oracle 9i it works OK (no error msgs)
> In oracle 8i :
> select * from more_reports2;
> returns :
>
> ERROR at line 1:
> ORA-03232: unable to allocate an extent of 14 blocks from tablespace 3
>
> Any suggestion what is going on?
>
> Thanks in advance for your answer.
  Received on Wed Jun 20 2001 - 11:29:38 CDT

Original text of this message

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