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:
- delete the data from the table where the index is part of
- rebuild the index with the following SQL command:
ALTER INDEX <indexname> REBUILD;
- enjoy the fix