Re: ORA-03232

Funnily enough I had the same message recently. Despite the overall excellence of oracle error messages, this one appears to be a little confusing.

If, as has been often recommended here, you RTFM, you will see that

ORA-03232 unable to allocate an extent of string blocks from tablespace string
Cause: An attempt was made to specify a HASH_MULTIBLOCK_IO_COUNT value that is greater than the tablespace's NEXT value. Action: Increase the value of NEXT for the tablespace using ALTER TABLESPACE DEFAULT STORAGE or decrease the value of HASH_ MULTIBLOCK_IO_COUNT. Tablespace 3 is almost certainly the temp tablespace and you have a query with a hash join writing to disk.

In my case, I simply increased the default storage parameters of the temp tablespace to 1M initial and next extent.

Of course, I hadn't rtfm'd myself, so I'd already increased the size of the temp tablespace before doing this.

James Antonie Rees <tony_rees_at_dmcwave.com> wrote in message news:1012999470.5479.0.nnrp-07.d4f0f429_at_news.demon.co.uk...
> What version of oracle is this. Normally this means that the max extents
> figure has been reached or there is not enough physical disk space to
> allocate the next block of data.
>
> If you are using Oracle 8 then you could set the EXTENT management to Auto
> Extend
>
> To find out look at the following code and run. Fillin the name of the
> Tablespacename
> select * from dba_tablespaces;
>
> select

tablespace_name,max_extents,status,extent_management,allocation_type
> from dba_tablespaces
>
> where tablespace_name = 'TABLESPACE_NAME_HERE'
>
> Good luck
>
>
>
> regards
>
>
>
> Tony
>
> ITD Hamilton Scotland
>
> DMC Stratex Networks
>
>
>
>
> "ARO_77" <wrack_at_kki.net.pl> wrote in message
news:3c610fba_at_news.vogel.pl...
> > What is wrong - even on exp i get such info:
> >
> > ORA-03232: unable to allocate an extent of 25 blocks from tablespace 3
> >
> > HELP !
> >
> >
>
>
Received on Wed Feb 06 2002 - 16:36:00 CST