SQL*Loader-00418: Bad datafile datatype for column string



SQL*Loader-00418: Bad datafile datatype for column string..

Answer / guest

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-23362: invalid user

1 Answers  


NNL-01011: Forwarding contexts freed: number

1 Answers  


NZE-28780: invalid data access method specified by the parameter

1 Answers  


ORA-31696: unable to export/import string using client specified string method

1 Answers  


ORA-07402: sprst: cannot restore user signal handler.

1 Answers  


ORA-19699: cannot make copies with compression enabled

1 Answers  


PLS-00135: Pragma string expects 3rd argument to be an identifier, string or numeric literal

1 Answers  


ORA-31004: Length string of the BLOB in XDB$H_INDEX is below the minimum string

1 Answers  


ORA-14553: cannot perform a lob write operation inside a query

1 Answers  


NCR-00001: NCR: Could not allocate memory

1 Answers  


DRG-50940: parser not parsed

1 Answers  


ORA-25225: invalid value string, DEQUEUE_MODE should be REMOVE or BROWSE or LOCKED

1 Answers  


Categories