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:56:50 -0400
Message-ID: <2rg9ruF1afjccU1@uni-berlin.de>

"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

Original text of this message

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