How to fix the Oracle error SQL*Loader-00288: Delimiters may not be specified for collections stored in SDF.?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00288: Delimiters may not be specified for collections stored in SDF. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00288: Delimiters may not be specified for collections stored in SDF.

Reason for the Error SQL*Loader-00288: Delimiters may not be specified for collections stored in SDF.

A TERMINATED BY or ENCLOSED BY clause was found along with an SDF (secondary data files) clause for a nested table or varray field.

How to fix the Error SQL*Loader-00288: Delimiters may not be specified for collections stored in SDF. ?

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

The TERMINATED BY or ENCLOSED BY clauses may be specified only if the nested table or VARRAY data is stored in the record in the main data file. If you are loading nested table or VARRAY data from a secondary data file, then you must use COUNT to indicate the number of elements in the secondary data file that are stored in the file.