Oracle Database - Data Load

1 - About

Data loading in a Oracle Database environment.

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

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

4 - Documentation / Reference

db/oracle/data_load.txt · Last modified: 2017/09/06 19:27 by gerardnico