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

From: Ms. D.H. Harvey <qq45_at_liverpool.ac.uk>
Date: 23 Sep 2004 15:27:28 GMT
Message-ID: <ciuq10$g8g$1@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 Received on Thu Sep 23 2004 - 10:27:28 CDT