Re: Should we be afraid of online index rebuild?

From: Hemant K Chitale <hkchital_nospam_at_singnet_nospam.com.sg>
Date: Wed, 13 Feb 2002 22:54:27 +0800
Message-ID: <a4dup9$a69$1@dahlia.singnet.com.sg>

Read Note 125149.1 : ALTER INDEX .. REBUILD ONLINE can Corrupt The Index affecting 8.1.5.x, 8.1.6.x and 8.1.7.0

Hemant K Chitale
http://hkchital.tripod.com
"NorwoodThree" <norwoodthree_at_my-deja.com> wrote in message news:ba03e2c.0202111619.50127740_at_posting.google.com...
> I really dont think you have to worry about rebuilding indexes
> online...just make sure you have enough space of course.
>
> You mentioned an accidental deletion of a table...thats not a problem
> with the index or Oracle software, it is a problem between keyboard
> and chair.
>
> Automate the process and test it on a test instance before you deploy
> it.
>
> Also, why are you rebuilding the indexes? Is this a frequent event?
> If so, you may have a design issue.
Received on Wed Feb 13 2002 - 08:54:27 CST