Oracle Error ORA-64143: Can only share an existing XMLIndex table with an XMLTYPE column.

Oracle Error Message

ORA-64143: Can only share an existing XMLIndex table with an XMLTYPE column.

Reason for the Error

An attempt was made to share a table without an XMLTYPE column.

Solution

Drop the group containing the XMLIndex table without an XMLTYPE column and re-create the group with new definition.