RE: dbms package? - analyze table validate structure
From: Yong Huang <yong321_at_yahoo.com>
Date: Fri, 2 Jan 2009 09:10:12 -0800 (PST)
Message-ID: <447103.72701.qm_at_web80605.mail.mud.yahoo.com>
> 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.
Date: Fri, 2 Jan 2009 09:10:12 -0800 (PST)
Message-ID: <447103.72701.qm_at_web80605.mail.mud.yahoo.com>
> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 02 2009 - 11:10:12 CST