How to fix the Oracle error ORA-30986: XML Index with more than one virtual column is disallowed?

In this post, you’ll learn more about the Oracle ErrorORA-30986: XML Index with more than one virtual column is disallowed with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-30986: XML Index with more than one virtual column is disallowed

Reason for the Error ORA-30986: XML Index with more than one virtual column is disallowed

An attempt was made to create an XML Index with more than one virtual column.

How to fix the Error ORA-30986: XML Index with more than one virtual column is disallowed ?

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

Create only one virtual column.