Oracle Error ORA-30964: The XML Index was not usable.

Oracle Error Message

ORA-30964: The XML Index was not usable.

Reason for the Error

The domain index for XML was not created properly. The Path Table is missing.

Solution

Drop and re-create the XML Index.