Oracle Database - Data Load

About

Data loading in a Oracle Database environment.

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

Oracle Version	Utility	Rows	Location
…	Oracle Database - Data Pump - (Export\|Import) Utilities	A lot	on server
in Oracle 9i and later	External Table	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: