About

Data loading in a Oracle Database environment.

In the Oracle Database, you can load data in the following elements:

Utilities

Oracle Version Utility Rows Location
Oracle Database - Data Pump - (Export|Import) Utilities A lot on server
in Oracle 9i and later Oracle Database - External Tables A lot on server
in Oracle 8i and earlier Oracle - SQL*Loader A lot on client
Apex Data Loader A few more Online
Insert statement A few Client

The best load approach for a lot of data is performed with external tables because external files can be:

  • queried
  • in parallel.

Documentation / Reference