Re: Rebuilding an index

From: benjamin zhang <bzhang_at_ei.org>
Date: 1997/03/18
Message-ID: <332EE7EF.3C40@ei.org>#1/1

Carlos A. Gonzalez wrote:
>
> Gentlemen:
>
> Here is my situation
>
> I have a badly fragmented INDEX object
>
> I am going to drop it
> I am going to recreate it using one single extent (storage INITIAL ????)
>
> My question is :
>
> How do I go about finding how big to make this first INITIAL extent ??
> Are there any other implications, such as enough space in the TABLESPACE ??
>
> Thank you
>
> Carlos
>
>

---

hi Carlos,

Check the USER_SEGMENTS to estimate the index size.

ben Received on Tue Mar 18 1997 - 00:00:00 CST