Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-1654 , Oracle asking for very large extent
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 DBAReceived on Mon Jul 31 2006 - 10:04:08 CDT