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



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

Answer / guest

Cause: 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.

Action: 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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02368: file string is not valid for this load operation

1 Answers  


ORA-12196: TNS:received an error from TNS

1 Answers  


ORA-00089: invalid instance number in ORADEBUG command

1 Answers  


ORA-01225: thread number string is greater than MAXINSTANCES string

1 Answers  


ORA-27072: File I/O error

1 Answers  


ORA-08230: smscre: failed to allocate SGA

1 Answers  


ORA-29888: cannot create domain index on a table with row movement enabled

1 Answers  


PCC-02347: PL/SQL found syntax errors

1 Answers  


ORA-25247: %s is not a recipient of specified message

1 Answers  


ORA-31517: CDC change table string.string already exists

1 Answers  


ORA-16609: one or more resources have failed

1 Answers  


ORA-00446: background process started when not expected

1 Answers  


Categories