ORA-01502: index ‘xxxx’ or partition of such index is in unusable state

Solution:

SOLUTION

select index_name,partition_name,status from dba_ind_partitions where status = ‘UNUSABLE’;
will list out index and partition in UNUSABLE state. Execute the following SQL to rebuild Index.

alter index xxxx rebuild partition xxx;

Comments are closed.