RE: dbms package? - analyze table validate structure

From: Yong Huang <>
Date: Fri, 2 Jan 2009 09:10:12 -0800 (PST)
Message-ID: <>

> As far as I can tell nothing is rebuilding the indexes, but I have not
> looked closely into that aspect of the problem. You bring up a valid
> point- doing an "alter index rebuild" does not solve the problem, it
> just moves the bad keys / pointers around. The index must be dropped
> and recreated.

Instead of dropping and recreating the index, why not rebuild the index online? It reads the table and really rebuilds it, with the benefit of allowing sessions to use the index uninterrupted and unblocked (almost).

Yong Huang       

Received on Fri Jan 02 2009 - 11:10:12 CST

Original text of this message