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:ciuq10$g8g$1_at_news.liv.ac.uk...
> ,paddy_nyr <mpprpp_at_yahoo.com> wrote:
>
> : "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.
>
> Puzzled. Oracle wants to allocate at least 127 blocks, 508k, in TEMP
> in one extent. You say the initial and next extent sizes on TEMP are
> both 1024000 bytes ie 1000k. There should not be a problem.
>
> Can you cut and paste the result of
> select * from dba_tablespaces where tablespace_name = 'TEMP';
> please?
>
> Helen
>
I gave the incorrect db_block_size I was looking at the wrong db, but the
db_block_size is 8192.
Also, here's the output from the above select statement.
TABLESPACE_NAMEINITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING EXTENT_MANAGEMENT
ALLOCATION_TYPE PLUGGED_IN
TEMP 1024000 1024000 1 0 0 ONLINE TEMPORARY LOGGING DICTIONARY USER NO
Received on Thu Sep 23 2004 - 10:56:50 CDT