Oracle Error SQL*Loader-00479: REF directive for column string expects number arguments; found number.

Oracle Error Message

SQL*Loader-00479: REF directive for column string expects number arguments; found number.

Reason for the Error

The number of arguments in the REF directive for the column is incorrect.

Solution

Specify the correct number of arguments for REF. Remember that the REF directive always requires a table name. Also, primary key REFs require one arguments for each field in the primary key.