Oracle Error ORA-23626: No eligible index on table string.string

Oracle Error Message

ORA-23626: No eligible index on table string.string

Reason for the Error

Table did not have an eligible index to use for comparison.

Solution

For a table to be compared using DBMS_COMPARISON, the table must have an appropriate index on a column of certain data types. Check the documentation for supported data types.