Re: Report error

Posted by ErmanArslansOracleBlog on Mar 23, 2016; 7:16am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Report-error-tp746p748.html

It seems there is an unusable index or index partition. Find it and rebuild.
If it is not reported in the error message, then check the unusable indexes in dba_indexes table;

select owner, index_name from dba_indexes where status='UNUSABLE';

For partitions, check Dba_ind_partitions and for sub partitions chechk dba_ind_subpartitions.

Rebuild the unusable partition or index and retry.

Example command:
ALTER INDEX REBUILD PARTITION <partition_name>;

ALTER INDEX <index_name> rebuild;