Oracle Error ORA-23629: string.string is not an eligible index on table string.string for comparison

Oracle Error Message

ORA-23629: string.string is not an eligible index on table string.string for comparison

Reason for the Error

The specified index was not an eligible index to use for comparison.

Solution

For a table to be compared using DBMS_COMPARISON, the table must have an appropriate index. Please specify an eligible index for the table to be compared.