Re: ORA-1654 , Oracle asking for very large extent

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 31 Jul 2006 08:35:59 -0700
Message-ID: <1154360159.367399.108340@m79g2000cwm.googlegroups.com>

sybrandb wrote:
> sethwai_at_yahoo.com wrote:
> > Hi,
> >
> > I received the following message :
> >
> > ORA-1654: unable to extend index LAWSON.GLTSET3 by 8192 in tablespace
> > I1
> >
> > The tablespace is set to EXTENT MANAGEMENT LOCAL AUTOALLOCATE.
> >
> > Is there a way I can effect the extent size that oracle is asking for?
> >
> >
> > My tablespace has 7GB of free space but none of the free extents is
> > large enough.
> >
> > Any suggestions on the best way to handle this?
> >
> > Lew
>
> Resize the datafile. Rebuilding the index might be a temporary solution
> also.
> extent management autoallocate is just what it says, so you just
> *CAN'T* influence anything.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Could this be caused by specifying an upper limit for the number of extents (MAX_EXTENTS) for the index? 8192 is 8KB.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Mon Jul 31 2006 - 10:35:59 CDT