Oracle - SQL*Loader
About
A utility data loader for the Oracle database
Articles Related
Syntax
Support
ORA-1722 invalid number
Reason: NLS_NUMERIC_CHARACTERS is equal to ',.' or '.,' based upon the Territory (NLS_LANG) you are in.
Example:
The NLS_LANG setting above results in ',.' For NLS_NUMERIC_CHARACTERS.
The number 13.4 is not valid in this case and produces ORA-1722.
Characters not loaded correctly due to an incorrect characterset specified
Reason: The characterset specified needs to be the characterset of the data to be loaded (unless the CHARACTERSET keyword is used).
ORA-02266: unique/primary keys in table referenced by enabled foreign keys
If you are trying to use the TRUNCATE Option, use the REPLACE option instead.
Field in data file exceeds maximum length
A variable length field defaults to 255 bytes for a CHAR. If no datatype is specified, it defaults to a CHAR of 255 bytes.
To avoid this error, set the datatype with a big buffer as:
....
"DESC" CHAR(5000)
....