Extraction, Transformation and Loading

One of the common tasks of a dba is to load data from external sources normally the data is supplied by flat files which then have to be transformed before being loaded into the database.

Most warehouse data will go through a series of steps before loading the data into the database.

Oracle provides a host of tools to cut time when loading data, which include


see SQL*Loader for more information

External Tables

see External Tables for more information

Datapump Utilities

see Data Pump for more information

Transportable Tablespaces

see Transportable Tables for more information