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

TNS-00104: Data stream open/access error

1 Answers  


ORA-02307: cannot alter with REPLACE option a type that is not valid

1 Answers  


QSM-02140: agg(expr) requires correspondng SUM(expr*expr) function

1 Answers  


ORA-23320: the request failed because of values string and string

1 Answers  


ORA-13854: Tracing for service(module/action) string on instance string is not enabled

1 Answers  






TNS-00270: %s: Terminal Error string

1 Answers  


PCC-00011: Already in a declare section at line number in file string

1 Answers  


NNO-00111: line string: data type "string" has syntax "string", should be "string", data ignored

1 Answers  


TNS-12519: TNS:no appropriate service handler found

1 Answers  


RMAN-06453: RECOVERABLE may only be used with datafile objects

1 Answers  


ORA-37041: (XSACQUIRE_DEP_TIMEOUT) Composite, concat, dimension map, or internal partition workspace object is locked by another user and the WAIT timed out.

1 Answers  


TNS-00042: INTCTL: CMANAGER already running. Start operation cancelled

1 Answers  


Categories