How to fix the Oracle error ORA-31172: cannot load XMLType column using direct path?

In this post, you’ll learn more about the Oracle ErrorORA-31172: cannot load XMLType column using direct path with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-31172: cannot load XMLType column using direct path

Reason for the Error ORA-31172: cannot load XMLType column using direct path

The table being loaded contained an XML column with object-relational or binary storage and supplemental logging wass enabled for the table. Direct path load is not supported for such table when supplemental logging is enabled.

How to fix the Error ORA-31172: cannot load XMLType column using direct path ?

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

Perform the load with conventional path mode.