Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-03232 : unable to allocate an extent of 127 blocks from tablespace 5
"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