How to fix the Oracle error ORA-64143: Can only share an existing XMLIndex table with an XMLTYPE column.?

In this post, you’ll learn more about the Oracle ErrorORA-64143: Can only share an existing XMLIndex table with an XMLTYPE column. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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

How to fix the Error ORA-64143: Can only share an existing XMLIndex table with an XMLTYPE column. ?

You can fix this error in Oracle by following the below steps

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