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

Oracle Error Message

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

Reason for the Error

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

Solution

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