Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Rebuilding and index

Rebuilding and index

From: Carlos A. Gonzalez <Carlos_A_gonzalez_at_us.dell.com>
Date: 1997/03/18
Message-ID: <01bc33c1$42041600$8a1ca68f@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 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US