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: ORA-1654 , Oracle asking for very large extent

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

From: sybrandb <sybrandb_at_gmail.com>
Date: 31 Jul 2006 08:04:08 -0700
Message-ID: <1154358248.066220.158330@p79g2000cwp.googlegroups.com>

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
Received on Mon Jul 31 2006 - 10:04:08 CDT

Original text of this message

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