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-13365: layer SRID does not match geometry SRID

1 Answers  


CLSS-02204: voting device not configured. [string] [string]

1 Answers  


DRG-11121: failed to read from file string

1 Answers  


ORA-12066: invalid CREATE MATERIALIZED VIEW command

1 Answers  


DRG-10307: no servers running

1 Answers  






TNS-00085: * reread - ask the process name to reread parameter files

1 Answers  


ORA-01278: error creating file 'string'

1 Answers  


ORA-13523: unable to allocate required space for return type

1 Answers  


ORA-12823: default degree of parallelism may not be specified here

1 Answers  


QSM-01024: materialized view, string, has unknown compile errors

1 Answers  


ORA-07452: specified resource manager plan does not exist in the data dictionary

4 Answers  


ORA-36996: (XSRELGID13) Valueset workspace object should be defined over dimension workspace object.

1 Answers  


Categories