How to fix ORA-01502 index or partition of such index is in usable state

If you get the error How to fix ORA-01502: index or partition of such index is in usable state in Oracle. It is possible that an index is broken from a table.


To fix this error, you can do the following:

rebuild the index with the following SQL command:


ALTER INDEX your_index_name REBUILD;