Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Urgent prb - unable to allocate an extent

Re: Urgent prb - unable to allocate an extent

From: Rob Edgar <robedgar_at_hkstar.com>
Date: Fri, 22 Sep 2000 20:45:53 +0800
Message-ID: <8qfkqo$6k1@imsp212.netvigator.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US