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-23414: materialized view log for "string"."string" does not record rowid values

1 Answers  


ORA-21709: cannot refresh an object that has been modified

1 Answers  


RMAN-06006: connected to target database: string (not mounted)

1 Answers  


ORA-24437: OCIStmtExecute called before OCIStmtPrepare2.

1 Answers  


TNS-01053: Connecting to string

1 Answers  






ORA-01881: timezone region id number is invalid

1 Answers  


ORA-02353: files not from the same unload operation

1 Answers  


TNS-00282: Connection Manager: Failed to force log, logging is off

1 Answers  


PCC-01006: EXEC statement cannot begin in Area A at line number in file string

1 Answers  


IMG-00515: incorrect number of input channels

1 Answers  


ORA-12001: cannot create log: table 'string' already has a trigger

1 Answers  


NNO-00800: Error: cannot read version from config database

1 Answers  


Categories