SQL*Loader-00474: no value set for dynamic file for column
string in table string row number
- 1 Answers
- 2245 Views
- I also Faced
- E-Mail Answers
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 |
LRM-00123: invalid character number found in the input file
ORA-01918: user 'string' does not exist
ORA-10575: Give up restoring recovered datafiles to consistent state: out of memory
ORA-01931: cannot grant string to a role
ORA-16093: dependent archive log destination is not LGWR-enabled
PCB-00556: Unrecoverable error. Fix previous errors and re-precompile
PROT-00410: Please ensure you have file creation privileges in the executing directory before running this tool.
KUP-04025: field extends beyond end of record
ORA-34141: (MXCGPUT00) You cannot use the ASSIGN keyword with DIMENSION workspace object.
ORA-29373: resource manager is not on
IMG-02006: 2FF06 - average color feature cannot be determined
ORA-36980: (XSRELGID02) Variable workspace object must have a numeric data type.
Oracle Errors 
