Oracle Error ORA-64116: XMLIndex Exchange Partition: incompatible XPath subsets

Oracle Error Message

ORA-64116: XMLIndex Exchange Partition: incompatible XPath subsets

Reason for the Error

The XMLIndexes on the two tables had different path subsets.

Solution

Correct the error and retry the command.