Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Urgent prb - unable to allocate an extent
Problem is its difficult to see how this applies to the user tablespace, I have 700mb of free space with 30mb contiguous space and the tablespaces next is only 128kb
Rob
<barryDOTchatfield_at_felixstoweDOTrmsDOTslb.com> wrote in message
news:39cb4e2f.91904281_at_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:45:53 CDT