Re: Rebuilding an index

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
>
>

Why not just use: initial + ( extents - 1) * next from user_segments and user_indexes

Voila !

-- 
Connor McDonald
Systems Administrator-Unix/Oracle
BHP Iron Ore
"You're not drunk if you can lie on the floor without holding on"
            - Dean Martin