Re: UNUSABLE Indexes
From: Arun Mathur <themathurs_at_gmail.com>
Date: Wed, 26 Dec 2007 20:16:33 -0800 (PST)
Message-ID: <e7ad3944-1a32-4fbf-b2dc-c14c27ae6d60@l6g2000prm.googlegroups.com>
Date: Wed, 26 Dec 2007 20:16:33 -0800 (PST)
Message-ID: <e7ad3944-1a32-4fbf-b2dc-c14c27ae6d60@l6g2000prm.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
Hello Dereck,
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.
Regards,
Arun
Received on Wed Dec 26 2007 - 22:16:33 CST