Re: UNUSABLE Indexes
From: Arun Mathur <themathurs_at_gmail.com>
Date: Thu, 27 Dec 2007 06:51:43 -0800 (PST)
Message-ID: <4e273a3c-fc1f-4626-b77c-24b8a6fb023f@f3g2000hsg.googlegroups.com>
Date: Thu, 27 Dec 2007 06:51:43 -0800 (PST)
Message-ID: <4e273a3c-fc1f-4626-b77c-24b8a6fb023f@f3g2000hsg.googlegroups.com>
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