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
>
Something seems amiss...There is 7GB of free space in the tablespace. The max extent allocated with AUTOALLOCATE is 8MB. Even if the free space was fractured, Oracle would break the allocation down into sub-extents which would fit into the free space available. So why can't the next extent of the index be allocated in a LMT running under AUTOALLOCATE that has 7GB of free space? My initial guess is that all of the assumptions leading to the conclusion are incorrect.
The easiest solution is to just add more space to the tablespace. You can also try to rebuild the index.
-- =================================================================== Brian Peasland dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - UnknownReceived on Mon Jul 31 2006 - 10:43:56 CDT