Re: ORA-01502

Did you try rebuilding the index that was in a unusable state? What happened? "but it did not work" does not give us a clue as to what happened...

Also, I'll advise you to apply all patches related to 8.1.7. The reason why the index became unusable could have to do with some bugs in 8.1.7 (Specifically the sqlldr with direct load option does this ... at least in 8.1.6.3)

Anurag

"Helena" <hmatijaca_at_sapo.pt> wrote in message news:b0a4574b.0208271026.696b3d1b_at_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 &apos;PERFAI.ACCOUNT3_I&apos;
> or partition of such index is in unusable state
>
> Can someone please help me with this
> Thanks
> Helena
Received on Tue Aug 27 2002 - 20:18:52 CDT