How to fix the Oracle error SQL*Loader-00479: REF directive for column string expects number arguments; found number.?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00479: REF directive for column string expects number arguments; found number. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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

How to fix the Error SQL*Loader-00479: REF directive for column string expects number arguments; found number. ?

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

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.