How to fix the Oracle error SQL*Loader-00472: collections can contain only one non FILLER field specification?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00472: collections can contain only one non FILLER field specification with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00472: collections can contain only one non FILLER field specification

Reason for the Error SQL*Loader-00472: collections can contain only one non FILLER field specification

More than one non filler field specification is found in a collection field’s member field list.

How to fix the Error SQL*Loader-00472: collections can contain only one non FILLER field specification ?

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

See correct syntax in the Utilities Manual. If indeed there is more than one attribute that makes up the particular collection, then it must be a collection of a object type which needs to be specified using the COLUMN OBJECT field specification syntax.