The parameter file stores the location of the input/output files.

The input data file stores delimited or raw data.

To execute the SQL*Load tool, you need at least three files:

The external table loads support parallel loading if datafile is big enough. External table loads – create an external table for the data stored in the datafile and execute INSERT statements to insert the data from the datafile into the target table.This way is much faster than the conventional path but subject to some restrictions. Direct path loads – creates data blocks in Oracle database block format from the datafile and directly write the data block to the database.Conventional path loads – construct INSERT statements from the contents of the input datafile based on the predefined specification and execute the inserts.SQL*Loader provides the following methods to load data: It can parse many delimited file formats such as CSV, tab-delimited, and pipe-delimited. SQL*Loader allows you to load data from an external file into a table in the database.

Summary: in this tutorial, you will learn how to use the Oracle SQL*Loader tool to load from a flat-file into a table in the database.

Bulk rename utility handle is invalid