How to fix the Oracle error SQL*Loader-00290: PIECED keyword (on column string) allowed only for lob or long columns?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00290: PIECED keyword (on column string) allowed only for lob or long columns with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00290: PIECED keyword (on column string) allowed only for lob or long columns

Reason for the Error SQL*Loader-00290: PIECED keyword (on column string) allowed only for lob or long columns

The PIECED keyword cannot be used for non lob or long columns.

How to fix the Error SQL*Loader-00290: PIECED keyword (on column string) allowed only for lob or long columns ?

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

Remove the PIECED keyword or use lob or long column type.