Re: ORA-03232

From: Jaap W. van Dijk <j.w.vandijk_at_hetnet.nl>
Date: Sat, 12 Jan 2002 00:21:11 GMT
Message-ID: <3c3f804f.2163292@news.freeler.nl>

From the manual (Oracle 8i Error Messages):

"ORA-03232 unable to allocate an extent of string blocks from tablespace string
Cause: An attempt was made to specify a HASH_MULTIBLOCK_IO_COUNT value that is greater than the tablespace's NEXT value. Action: Increase the value of NEXT for the tablespace using ALTER TABLESPACE DEFAULT STORAGE or decrease the value of HASH_ MULTIBLOCK_IO_COUNT." So look up your HASH_MULTIBLOCK_IO_COUNT in V$parameter and adjust it (or NEXT) accordingly.

Jaap.

On Fri, 11 Jan 2002 19:57:27 GMT,
SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK (Brian Tkatch) wrote:

snip
>
>ERROR at line 1:
>ORA-03232: unable to allocate an extent of 127 blocks from tablespace
>3
>

snip
>
>Brian
Received on Fri Jan 11 2002 - 18:21:11 CST