How to fix the Oracle error ORA-26092: only LONG or LOB types can be partial?

In this post, you’ll learn more about the Oracle ErrorORA-26092: only LONG or LOB types can be partial with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-26092: only LONG or LOB types can be partial

Reason for the Error ORA-26092: only LONG or LOB types can be partial

A column which is not a LONG or LOB had the

* OCI_DIRPATH_COL_PARTIAL flag associated with it.

* Only LONG or LOB type columns can be loaded in pieces.

How to fix the Error ORA-26092: only LONG or LOB types can be partial ?

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

Do not use the OCI_DIRPATH_COL_PARTIAL flag for the column.