Loading_Mode

Value	Description
Insert_Update	The Data Loader inserts data and updates existing data. Full error reporting is supported with this option. This is the default.
Insert_Only	Allows data to only be inserted, making it faster than Insert_Update. Full error reporting is supported with this option. The Data Loader will not look for existing records and reduces data loading time by an average of 30%.
Insert_Only_Array	Allows fast bulk loading, and limited error reporting. The Data Loader uses array inserts with SQL Server databases, which improves performance further.

The Loading_Mode option controls whether data can be inserted by the Data Loader and whether existing data can be updated. It also controls how extensive error reporting is.

Due to the limited capabilities of Microsoft's ODBC driver for Oracle, Insert_Only_Array is equivalent to Insert_Only for the Oracle database.

For ownership data, Insert_Update is the only valid option.