Re: UNUSABLE Indexes
Date: Thu, 27 Dec 2007 06:51:43 -0800 (PST)
On Dec 27, 8:51 am, bhonaker <bhona..._at_gmail.com> wrote:
> On Dec 26, 5:10 pm, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote:
> > Oracle 10.2.0.3.0, Windows 2003 Server
> > Is there ANY possible way that an index marked as unusable can become valid
> > other than by either rebuilding or recreating?
> > Thanks
> TRUNCATEing a table will mark the indexes as VALID. I found this in
> Jeff Moss's blog, more info here:http://oramossoracle.blogspot.com/2006/07/truncate-command-marks-prev...
That is very interesting. Thanks for passing it on. Received on Thu Dec 27 2007 - 08:51:43 CST