Oracle Error ORA-64137: Cannot drop an XMLIndex whose internal table has been indexed using Oracle Text.

Oracle Error Message

ORA-64137: Cannot drop an XMLIndex whose internal table has been indexed using Oracle Text.

Reason for the Error

An attempt was made to drop an XMLIndex whose internal table has been indexed using Oracle Text.

Solution

Drop the Oracle Text index on the XMLIndex internal table.