ORA-01502

From: Helena <hmatijaca_at_sapo.pt>
Date: 27 Aug 2002 11:26:10 -0700
Message-ID: <b0a4574b.0208271026.696b3d1b@posting.google.com>

Hi there

One of the developers is having issues with oracle 8170 on a sun server..
I have drop all the indexes and created them but it did not work, also I have done alter session "ALTER SESSION SET SKIP_UNUSABLE_INDEXES=TRUE;" and did not work

DESC>Database ExecuteCommand() failed</DESC>

<VERBOSE>ORA-01502: index 'PERFAI.ACCOUNT3_I' or partition of such index is in unusable state

Can someone please help me with this
Thanks
Helena Received on Tue Aug 27 2002 - 13:26:10 CDT