How to fix the Oracle error SQL*Loader-00262: PIECED keyword (on column string) allowed only when path is direct?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00262: PIECED keyword (on column string) allowed only when path is direct with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00262: PIECED keyword (on column string) allowed only when path is direct

Reason for the Error SQL*Loader-00262: PIECED keyword (on column string) allowed only when path is direct

The PIECED keyword cannot be used in a conventional path load.

How to fix the Error SQL*Loader-00262: PIECED keyword (on column string) allowed only when path is direct ?

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

Remove the PIECED keyword or use the direct path load.