Re: UNUSABLE Indexes
Date: Wed, 26 Dec 2007 20:16:33 -0800 (PST)
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?
You would have to either rebuild or recreate. See http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_1008.htm#i2160588 for more information.
Arun Received on Wed Dec 26 2007 - 22:16:33 CST