How to fix ORA-01502: index or partition of such index is in usable state?
When I tried to delete the duplicate rows from the table, I received the "ORA-01502: index or partition of such index is in un-usable state" error message;
When I tried to rebuild the index by using the following command:
ALTER INDEX index_name REBUILD