ORA-01502: index or partition of such index is in unusable state

Problem 

  select * from advice_note

  where telephone_no='763283';

select * from advice_note

*

ERROR at line 1:

ORA-01502: index 'DOTSOFT.INX_ADVICE_NOTE_TELNO' or partition of such index is in unusable state

Solution

Rebuild the index

alter index INX_ADVICE_NOTE_TELNO rebuild;

Index altered.

 select * from advice_note    where telephone_no='763283';

ITW18F           06-JAN-01 MHNP200103F96     NPCP                  763283

OFFLINE- NPC A/NOTE

C GE76-570366                     ITW