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 : unable to allocate an extent of 127 blocks from tablespace 5

Re: ORA-03232 : unable to allocate an extent of 127 blocks from tablespace 5

From: paddy_nyr <mpprpp_at_yahoo.com>
Date: Thu, 23 Sep 2004 11:07:13 -0400
Message-ID: <2rg6utF18snb5U1@uni-berlin.de>

"Ms. D.H. Harvey" <qq45_at_liverpool.ac.uk> wrote in message news:ciuo6t$f72$1_at_news.liv.ac.uk...
> ,paddy_nyr <mpprpp_at_yahoo.com> wrote:
> : I get the following message on a select statement and tablespace 5 is
temp.
>
> : My initiatl exetent and next extent on TEMP are set at 1024000 and my
> : hash_io_block_count = 0.
>
> : Any insite is most appreciated.
>
> : I'm using Oracle 8.1.7.4 on Solaris 8.
>
> : Thanks
>
> What is your database block size?
>
> Helen
>

My db_block_size = 4096. Received on Thu Sep 23 2004 - 10:07:13 CDT

Original text of this message

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