Oracle Error ORA-29939: could not implicitly transform user-managed domain index to system-managed domain index

Oracle Error Message

ORA-29939: could not implicitly transform user-managed domain index to system-managed domain index

Reason for the Error

Implicit validation of a user-managed domain index with a system-managed indextype failed.

Solution

Issue an ALTER INDEX COMPILE command on the domain index.