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-14316table is not partitioned by List method
ORA-39171Job is experiencing a resumable wait. string
ORA-02168invalid value for FREELISTS
RMAN-08522input datafile file number=string name=string
ORA-13789invalid process action
ORA-31509publication does not exist
ORA-24812character set conversion to or from UCS2 failed
SQL-02106Inconsistent cursor cache. Invalid Oracle cursor number
ORA-08111a partitioned index may not be coalesced as a whole
IMP-00049Unknown language specified in CHARSET
ORA-09831snyStartThread: failed to build the server port set.
ORA-29311export dump file was not generated by this database, string does not match
DIA-48312Sweep incident string staging file failed
ORA-21707pin duration is longer than allocation duration
ORA-53017The installation file string has an incorrect document type
RMAN-06583at least 1 channel of TYPE DISK must be allocated to use AS COPY option
ORA-37602(XSPGERRTEMPUSER) Ran out of temporary storage while writing to analytic workspace string. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
DIA-48440Variable [string] is already defined
ORA-27002function called with invalid device structure
ORA-13979Filename too long




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