RE: dbms package? - analyze table validate structure
Date: Fri, 2 Jan 2009 12:15:38 -0500
Message-ID: <56211FD5795F8346A0719FEBC0DB067503945418_at_mds3aex08.USIEXCHANGE.COM>
My understanding of "rebuild index online" is that it does not read the table, rather it just reads the current index while building a new index, and at the end renames the new object while deleting the old object. This is why the rebuild index can be so much faster that a true create index.
Regardless of how it actually works, I have found that this does not fix the problem- the index must be dropped first. I wish this did work, it would have gone much faster in my case.
-----Original Message-----
From: Yong Huang [mailto:yong321_at_yahoo.com]
Sent: Friday, January 02, 2009 12:10 PM
To: oracle-l_at_freelists.org
Cc: Crisler, Jon
Subject: RE: dbms package? - analyze table validate structure
> 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:15:38 CST