Re: Urgent prb - unable to allocate an extent

From: <barryDOTchatfield_at_felixstoweDOTrmsDOTslb.com>
Date: Fri, 22 Sep 2000 12:19:46 GMT
Message-ID: <39cb4e2f.91904281@news.sinet.slb.com>

Aren't manuals wonderful things...

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. On Fri, 22 Sep 2000 19:00:08 +0800, "Rob Edgar" <robedgar_at_hkstar.com> wrote:

>I am trying to insert records into a table and get the following error
>
> ORA-03232: unable to allocate an extent of 12 blocks from tablespace 3
>
>I cant figure out which is tablespace 3 but I guess its my Users which is
>where this table is but I have 400mb of space the table itself is in one
>extent and currently is 50mb in size so I dont get it??
>
>
>Anyone know what the problem might be
>TIA
>Rob
>
>
Received on Fri Sep 22 2000 - 07:19:46 CDT