ORA-01502 – Oracle Index in Unusable State

Dica rápida, pra resolver:

1) liste quem são:

SQL> select index_name, owner from dba_indexes where status=’UNUSABLE’;

INDEX_NAME                     OWNER
—————————— ——————————
MDS_SD_U1                      SOADB_MDS

2) Faça rebuild.

SQL> alter index SOADB_MDS.MDS_SD_U1 rebuild;

Index altered.

SQL>  select index_name, owner from dba_indexes where status=’UNUSABLE’;

no rows selected

SQL>

That’s all!