Re: UNUSABLE Indexes
From: bhonaker <bhonaker_at_gmail.com>
Date: Thu, 27 Dec 2007 05:51:34 -0800 (PST)
Message-ID: <1c6d5bce-e388-493e-bed6-e8c01af663bb@r60g2000hsc.googlegroups.com>
Date: Thu, 27 Dec 2007 05:51:34 -0800 (PST)
Message-ID: <1c6d5bce-e388-493e-bed6-e8c01af663bb@r60g2000hsc.googlegroups.com>
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-previously.html
Received on Thu Dec 27 2007 - 07:51:34 CST