Oracle Error ORA-14196: Specified index cannot be used to enforce the constraint.

Oracle Error Message

ORA-14196: Specified index cannot be used to enforce the constraint.

Reason for the Error

The index specified to enforce the constraint is unsuitable for the purpose.

Solution

Specify a suitable index or allow one to be built automatically.