Oracle - SQL*Loader

> Oracle - SQL*Loader

1 - About

A utility data loader for the Oracle database

Advertising

3 - Syntax

4 - Support

4..1 - 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.

4..2 - 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).

4.1 - 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.

4.2 - 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)
....
Advertising

5 - Documentation / Reference

sql_loader/sql_loader.txt · Last modified: 2017/09/06 19:30 by gerardnico