RE: dbms package? - analyze table validate structure
- From: "Crisler, Jon" <Jon.Crisler@xxxxxxx>
- To: <yong321@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 2 Jan 2009 12:15:38 -0500
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@xxxxxxxxx]
Sent: Friday, January 02, 2009 12:10 PM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
