Oracle Database - Data Load

Card Puncher Data Processing


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

Discover More
Card Puncher Data Processing
Data Processing - (Batch|Bulk) Processing

An batch processing systems (bulk,offline) means: starting a process, reading a lot of data in batch (in parallel if possible) and terminating the process Simple code iterates generally...
Card Puncher Data Processing
Oracle Database - Data Loading Hint

The PL/SQL data loading procedures use the following HINTS for performance. They are /+ APPEND NOLOGGING PARALLEL / Append: - When “Append” hint is used in a PL/SQL INSERT statement, Oracle will...
Card Puncher Data Processing
Oracle Database - How can we load a large number of rows into an indexed existing table ?

If you have to perform data load into a or data mart, you must skip the index to minimize the generation of redo log, such as : set the indexes to the state. They are not dropped but just setting...
Card Puncher Data Processing
Oracle Database - Partition Exchange for Data Movement / Data Load

One of the most challenging aspects of data warehouse administration is the development of ETL (extract, transform, and load) processes that load data from OLTP systems into data warehouse databases. ...
Card Puncher Data Processing
Oracle Database - Redo Size statistics

The redo size statistics shows how much redo log your statement generated when executed. The redo size statistics is most useful when judging the efficiency of large bulk operations with statements...

Share this page:
Follow us:
Task Runner