ORA-01502: index or partition of such index is in usable state problem
Faced a similar issue.
If you just need to get rid of the error, do:
SELECT 'ALTER INDEX '||OWNER||'.'||INDEX_NAME||' REBUILD;'
FROM DBA_INDEXES
WHERE STATUS = 'UNUSABLE';

This will output ALTER INDEX ... REBUILD; statements for all &quot;unusable&quot; indexes. Run them, so that the indexes can be &quot;usable&quot; again.