SQL*Loader-00418: Bad datafile datatype for column string
- 1 Answers
- 3475 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-06032: NETDNT: connect failed, access control data rejected
PLS-00330: invalid use of type name or subtype name
RMAN-08059: media recovery failed
ORA-23423: job number string is not positive
TNS-12639: Authentication service negotiation failed
IMP-00052: Warning: Unable to set event for freelist communication with server
ORA-01334: invalid or missing logminer dictionary processes context
ORA-23611: tablespace "string" has more than one data file
AMD-00145: error attaching Workspace "string" in mode "string"
PCC-00044: Array size mismatch in INTO/USING. Minimum is: string(number:number)
KUP-04068: internal error fetching attribute string
LPX-00609: Function call with invalid number of arguments in '~1S'.
Oracle Errors 
