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-16731: Error executing dbms_logstdby.unskip_txn procedure

1 Answers  


ORA-02495: cannot resize file string, tablespace string is read only

1 Answers  


ORA-29807: specified operator does not exist

1 Answers  


ORA-13224: zero tolerance specified for layer in USER_SDO_GEOM_METADATA

1 Answers  


SQL*Loader-00708: Internal error: unknown status number returned from sllf layer

1 Answers  






ORA-21524: object type mismatch

1 Answers  


ORA-13127: failed to generate target partition

1 Answers  


TNS-00554: write failed

1 Answers  


ORA-29538: Java not installed

1 Answers  


ORA-32155: Anydata not specified

1 Answers  


ORA-31662: metadata transform name can not be defaulted

1 Answers  


ORA-06119: NETTCP: spurious client request

1 Answers  


Categories