Re: ORA-03232

>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

Well, I tried this:

SELECT Value FROM V$Parameter WHERE Name = 'hash_multiblock_io_count';

VALUE

1 row selected.

So, I'm not sure that I can decrease it.

SELECT NEXT_EXTENT FROM user_tablespaces where tablespace_name = 'TEMP'; NEXT_EXTENT

      65536

1 row selected.

It seems to be nice.

host df -h /u01

Filesystem            Size  Used Avail Use% Mounted on
/dev/sda6              22G   16G  4.7G  77% /u01

Seems to be room enough to expand.

 host ls -lh temp*
-rw-r--r--   1 oracle   dba          1.0G Jan 11 14:47 temp01.dbf
-rw-r--r--   1 oracle   dba          200M Jan 11 14:47 temp02.dbf
-rw-r--r--   1 oracle   dba          200M Jan 11 14:47 temp03.dbf

Seems to have another some time to go before being full (files are limited to 1 gig). The first file should be empty anyway.

Brian Received on Mon Jan 14 2002 - 09:38:35 CST