SQL*Loader-00418: Bad datafile datatype for column string
- 1 Answers
- 2862 Views
- I also Faced
- E-Mail Answers
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 |
ORA-19677: RMAN configuration name exceeds maximum length of string
ORA-12502: TNS:listener received no CONNECT_DATA from client
ORA-32631: illegal use of objects in MODEL
NID-00335: The following datafiles are not consistent:
ORA-06950: No error
ORA-13348: polygon boundary is not closed
ORA-06605: LU6.2 Driver: Unexpected line turnaround
ORA-12081: update operation not allowed on table "string"."string"
NNO-00063: cannot construct domain checkpoint file name
PCC-00051: Size of VARCHAR string is larger than 65533 in line number in file string
IMG-00854: internal image data free failed
ORA-35062: (QFGET01) Duplicate files found for extension number number of EIF file string.
Oracle Errors 
