Rebuilding an index

From: Carlos A. Gonzalez <Carlos_A_gonzalez_at_us.dell.com>
Date: 1997/03/18
Message-ID: <01bc33c2$0754c800$8a1ca68f_at_127.0.0.1.us.dell.com>#1/1


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   Received on Tue Mar 18 1997 - 00:00:00 CET

Original text of this message