Raghu,

I would use alter index move .... command to rebuild
your index. That way your index is online while being
rebuild.

Ashish
--- Raghu Kota <[Email Address Removed] wrote:
>
> Hi Friends
>
> What is the best way of rebuilding of following
> Index??
>
> Index has total size 5.8Gb But lot of deletions, may
> be the real data around
> 2.5Gb has initial extent 71M, next 197M. So How my
> doubt which is best way
> for setting initial=next or give more space for
> initial for putting more
> data in initial itself and keep next as it is??? Any
> ideas???
>
> Thanks in advance
> Raghu.
>
>
>
_________________________________________________________________
> Get your FREE download of MSN Explorer at
> http://explorer.msn.com/intl.asp
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>


__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
Oracle LazyDBA home page