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-06032: NETDNT: connect failed, access control data rejected

1 Answers  


PLS-00330: invalid use of type name or subtype name

1 Answers  


RMAN-08059: media recovery failed

1 Answers  


ORA-23423: job number string is not positive

1 Answers  


TNS-12639: Authentication service negotiation failed

1 Answers  


IMP-00052: Warning: Unable to set event for freelist communication with server

1 Answers  


ORA-01334: invalid or missing logminer dictionary processes context

1 Answers  


ORA-23611: tablespace "string" has more than one data file

1 Answers  


AMD-00145: error attaching Workspace "string" in mode "string"

1 Answers  


PCC-00044: Array size mismatch in INTO/USING. Minimum is: string(number:number)

1 Answers  


KUP-04068: internal error fetching attribute string

1 Answers  


LPX-00609: Function call with invalid number of arguments in '~1S'.

1 Answers  


Categories