Re: ora -03232

Stephen Bell <stephen.bell_at_cgi.ca> wrote in message news:<3B30CF71.BD920B1D_at_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.

Thanks for your hint

   problem was in TEMP tablespace(too small init and next alocations)    select creates internal cortasian product ;-(    and uses disk for sort :-(( like a resalt i get ORA 03232

                                 73.Leo.