Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

LPX-00235: invalid XML version, must be 1.0 or 2.0

1 Answers  


LSX-00248: invalid duration "~S"

1 Answers  


ORA-27200: skgfpgo: sbtpcstart returned error

1 Answers  


ORA-01912: ROW keyword expected

1 Answers  


ORA-29505: AS keyword is invalid in CREATE JAVA CLASS or RESOURCE

1 Answers  






PCC-02439: FOR clause not allowed in this COLLECTION statement

1 Answers  


ORA-02242: no options specified for ALTER INDEX

1 Answers  


TNS-00519: Operating system resource quota exceeded

2 Answers  


ORA-13368: simple polygon type has more than one exterior ring

1 Answers  


NNC-00411: invalid default domain name "string"

1 Answers  


ORA-27067: size of I/O buffer is invalid

1 Answers  


ORA-07505: scggt: $enq parent lock unexpected return

1 Answers  






Categories