APP-AR-11526: 'ORA-01502: index 'XX.XXXXX' or partition of such index is

This issue comes up because you have made a partition of an Index UNUSABLE.

To resolve the error you can follow the below steps.


1. Drop Index
OR
2. Rebuild Index
OR
3. Rebuild Partition of the Index


This Should resolve your issue.

1. To Drop:-

DROP INDEX SCHEMA_NAME.INDEX_NAME FORCE (Force only for non domain index)

DROP INDEX SCHEMA_NAME.INDEX_NAME

2. To Rebuild Index :-

ALTER INDEX SCHEMA_NAME.INDEX_NAME UNUSABLE;

3. To Rebuild Partition:-

ALTER EMPLOYEE_SUBPARTITIONS MODIFY DEFAULT ATTRIBUTES FOR PARTITION P1 TABLESPACE TS1.