Oracle Error SQL*Loader-00478: unable to continue due to missing filename for LOBFILE or SDF

Oracle Error Message

SQL*Loader-00478: unable to continue due to missing filename for LOBFILE or SDF

Reason for the Error

The name for a LOBFILE or secondary data file is either missing or NULL for the current row. SQL*Loader is unable to continue loading since it can’t determine how to get the LOB for the next row.

Solution

Correct the data file so that there are valid values for all fields containing the names of LOBFILEs and secondary data files.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...