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-33300: (DBERR22) Analytic workspace string cannot be opened because it was last modified by an incompatible version of string.

1 Answers  


ORA-15002: parameter LOCK_NAME_SPACE exceeds limit of string characters

1 Answers  


ORA-01983: invalid auditing option for DEFAULT

1 Answers  


PLS-00520: MAP methods must be declared without any parameters other than (optional) SELF.

1 Answers  


KUP-04089: column transform string is not the name of a table column

1 Answers  






ORA-31093: null or invalid value specified for parameter : string

1 Answers  


TNS-01099: %s * string * string * string * number

1 Answers  


TNS-12650: No common encryption or data integrity algorithm

1 Answers  


DRG-11128: invalid format of rule

1 Answers  


RMAN-06515: archived logs required to recover from this copy will expire when this copy expires

1 Answers  


ORA-12566: TNS:protocol error

1 Answers  


NCR-03005: NCRO: Orphan message

1 Answers  


Categories