How to fix the Oracle error SQL*Loader-00970: enabled constraint on an XML column not allowed in direct path?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00970: enabled constraint on an XML column not allowed in direct path with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00970: enabled constraint on an XML column not allowed in direct path

Reason for the Error SQL*Loader-00970: enabled constraint on an XML column not allowed in direct path

An enabled check constraint existed on an XML column.

How to fix the Error SQL*Loader-00970: enabled constraint on an XML column not allowed in direct path ?

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

Disable the check constraint before attempting to load the table data using the direct path mode, or leave the constraint enabled but use the conventional path mode instead.