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: ARO_77 <wrack_at_kki.net.pl>
Date: Wed, 6 Feb 2002 15:02:08 +0100
Message-ID: <3c61393a@news.vogel.pl>


Oracle 8.1.7.2 (64-bit)

  1. there is enough physical disk space
  2. Auto Extend is ON i don't know what to do ???

Użytkownik James Antonie Rees <tony_rees_at_dmcwave.com> w wiadomości do grup dyskusyjnych napisał: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 - 08:02:08 CST

Original text of this message

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