SQL*Loader-00418: Bad datafile datatype for column string
Cause: 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.
Action: Determine the datatype of the column in the database check the documentation for the correct mechanisms to use to load columns of that type.
Cause: 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.
Action: Determine the datatype of the column in the database check the documentation for the correct mechanisms to use to load columns of that type.
No comments:
Post a Comment