Oracle Error Message
SQL*Loader-00418: Bad datafile datatype for column string
Reason for the Error
The datatype in the data file specified for the column cannot be used to load the column. This message is often displayed for columns that need to be loaded with special features. For example, BFILE columns can only be loaded via the BFILE directive in the control file; same goes for REF fields. in the SQL*Loader control file. Similarly, REF columns can only be loaded with theREF datatype in the SQL*Loader control file.
Solution
Determine the datatype of the column in the database check the documentation for the correct mechanisms to use to load columns of that type.
