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

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-03232

Re: ORA-03232

From: James Antonie Rees <tony_rees_at_dmcwave.com>
Date: Wed, 6 Feb 2002 12:42:32 -0000
Message-ID: <1012999470.5479.0.nnrp-07.d4f0f429@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 - 06:42:32 CST

Original text of this message

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