Oracle Error ORA-38451: index is in an inconsistent state

Oracle Error Message

ORA-38451: index is in an inconsistent state

Reason for the Error

One or more secondary objects used to maintain the index did not exist

Solution

Drop the index and recreate it.