Direct-load, also known as direct path load, is a process of formatting Oracle data blocks and writing the data blocks directly to the database files.
You can, for example, choose to do direct-load operations with SQL*Loader.
The direct-load does not compete with other users for database resources so it can usually load data faster.
Oracle SQL*Loader is flexible and offers many options that should be considered to maximize the speed of data loads. These include:
- Use Direct Path Loads - The conventional path loader essentially loads the data by using standard insert statements.
The direct path loader (direct=true) loads directly into the Oracle data files and creates blocks in Oracle database block format.
The fact that SQL is not being issued makes the entire process much less taxing on the database.
There are certain cases, however, in which direct path loads cannot be used (clustered tables).
To prepare the database for direct path loads, the script