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:

• 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