Re: Index reaching max extents

On Mon, 13 Sep 1999 18:31:32 -0500, Tapan Trivedi <tapan.trivedi_at_abbnm.com> wrote:
>
>Hey guys,
> I have an index which is reaching near its max extents and I am not in
>a position to increase the max-extents due to the restrictions posed
>upon the system. What can I do ? Will rebuilding the index solve the
>problem ??
>
>Any hints ,experiences , suggestions are welcome.
>

ALTER INDEX <index_name> REBUILD
STORAGE (INITIAL <set to value equal to the following query> NEXT <depends on growth, I usually set it to 1/2 of INITIAL>)

select extents, bytes, owner||'.'||segment_name, segment_type from dba_segments
where segment_name=<index_name>

Example
ALTER INDEX MANAGER_PK REBUILD
STORAGE (INITIAL 100M NEXT 50M)

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email