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

Oracle Error Message

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

Reason for the Error

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

Solution

Drop the Oracle Text index on the XMLIndex internal table.