SQL*Loader-00418: Bad datafile datatype for column string
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 documentation for the correct mechanisms to use to load columns of that type.
SQL*Loader-00419
Custom Search


More Oracle errors
ORA-08002sequence string.CURRVAL is not yet defined in this session
TNS-12556TNS:no caller
RMAN-06909WARNING: parallelism require Enterprise Edition
ORA-10632Invalid rowid
ORA-31417column list contains control column string
SQL*Loader-00118Invalid parallel load option
ORA-09834snyGetPortSet: failed to collect info on a port.
ORA-01229data file string is inconsistent with logs
ORA-09790sllfcf: unable to close file.
ORA-25304Cannot use priority order queues for capture LCRs
TNS-12625TNS:missing argument
ORA-31485invalid database link
SQL*Loader-00473nesting of collections is not allowed.
ORA-29295invalid mime header tag
ORA-16627operation disallowed since no standby databases would remain to support protection mode
OCI-31028Resource metadata length string exceeded maximum length string
ORA-33010(XSAGDNGL04) Relation workspace object is duplicated in the AGGMAP workspace object.
DGM-16934You must start instance "string" manually
ORA-26080file "string" is not part of table string.string partition string
ORA-36278(XSCGMDLAGG07) workspace object does not exist or is not valueset.




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16665timeout waiting for the result from a database
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
ORA-16766Redo Apply is stopped
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-00001unique constraint (string.string) violated
ORA-55508Invalid input to Flashback Transaction Backout




Your own TOP 20 Oracle errors
SQL*Loader-00418Bad datafile datatype for column string