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

PLS-00393: wrong number of columns in SELECT...INTO statement

1 Answers  


TNS-12522: TNS:listener could not find available instance with given INSTANCE_ROLE

1 Answers  


TNS-12528: TNS:listener: all appropriate instances are blocking new connections

1 Answers  


ORA-29746: Cluster Synchronization Service is being shut down.

1 Answers  


ORA-08463: overflow converting decimal number to Oracle number

1 Answers  






ORA-13389: unable to compute buffers or intersections in analysis function

1 Answers  


ORA-12495: cannot disable an enabled level, category, or release category

1 Answers  


ORA-29880: such column list already indexed using another domain index and indextype

1 Answers  


ORA-12927: RETENTION option already specified

1 Answers  


RMAN-04022: target database mount id string does not match channel's mount id string

1 Answers  


TNS-12534: TNS:operation not supported

1 Answers  


ORA-27508: IPC error sending a message

1 Answers  


Categories