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

ORA-12016: materialized view does not include all primary key columns

1 Answers  


DRG-10305: pipe string is full

1 Answers  


ORA-30016: undo tablespace 'string' is already in use by this instance

1 Answers  


ORA-33024: (XSAGDNGL11) AGGMAP workspace object contains duplicate information.

1 Answers  


ORA-02781: Invalid value given for the timing wanted flag

1 Answers  






ORA-29553: class in use: string.string

1 Answers  


PCC-02390: No EXEC SQL CONTEXT USE statement encountered

1 Answers  


ORA-24171: creation properties are only for internal use

1 Answers  


ORA-03248: Too much of segment creation activity during migration

1 Answers  


PCC-02404: This indicator variable must be declared as a pointer type

1 Answers  


DRG-10852: Invalid scoring type string specified for query template

1 Answers  


ORA-30508: client logon triggers cannot have BEFORE type

1 Answers  


Categories