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

SQL*Loader-00121: Invalid skip_unusable_indexes option

1 Answers  


QSM-02183: Expression to enable PCT not in PARTITION BY of analytic function or SPREADSHEET

1 Answers  


ORA-39703: server version and script version do not match

1 Answers  


TNS-02518: key negotiation error

1 Answers  


ORA-12552: TNS:operation was interrupted

1 Answers  






DRG-50859: failed to allocate statement handle

1 Answers  


PCC-01007: WORKING-STORAGE SECTION not found

1 Answers  


ORA-16633: The only instance of the database cannot be removed.

1 Answers  


SQL*Loader-00426: count of elements in VARRAY string comes after the data for the varray

1 Answers  


TNS-12642: No session key

1 Answers  


TNS-03506: Failed to create address binding

1 Answers  


RMAN-03012: fatal error during compilation of command

1 Answers  


Categories