SQL*Loader-00474: no value set for dynamic file for column
string in table string row number



SQL*Loader-00474: no value set for dynamic file for column string in table string row number..

Answer / guest

Cause: The data for the named column is in a dynamic LOBFILE
or secondary data file. This message is returned when the
field containing the name of the file with the data for this
field has not been set or is NULL. This could be because the
record in the data file does not match the format described
by the SQL*Loader control file.

Action: Correct any errors in the data file or the
SQL*Loader control file.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00603: Maximum length number of column string is too big for bind array

1 Answers  


RMAN-06468: Invalid Data Block Address: number

1 Answers  


PCB-00404: %s

1 Answers  


NID-00371: Change database name of database string to string? (Y/[N]) =>

1 Answers  


ORA-32743: command cannot be executed on remote instance

1 Answers  


DRG-11861: CSO-server Replies

1 Answers  


PLS-01404: ANSI Identifiers can only consist of letters, digits, and the underscore character

1 Answers  


PCC-00080: TYPE identifier already TYPEd

1 Answers  


NNL-00005: no server has been set. Use the "SET SERVER" command first

1 Answers  


ORA-09856: smpalo: vm_allocate error while allocating pga.

1 Answers  


ORA-31196: XML nodes over string in size cannot be printed

1 Answers  


ORA-24396: invalid attribute set in server handle

1 Answers  


Categories