About
Data loading in a Oracle Database environment.
In the Oracle Database, you can load data in the following elements:
- View ,
Articles Related
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.