Oracle Error SQL*Loader-00477: REF directive for field string requires at least two arguments

Oracle Error Message

SQL*Loader-00477: REF directive for field string requires at least two arguments

Reason for the Error

The SQL Loader control file contains a REF directive for the field, but only one argument was supplied for the directive. The REF directive always requires at least two arguments.

Solution

Supply the missing argument to the REF directive. Remember that you must always supply a table name to the REF directive even if the REF is scoped.