SQL
Loader
SQL*Loader allows you to load data from an external
file into a table in the database. It can parse many delimited file formats
such as CSV, tab-delimited, and pipe-delimited.
SQL*Loader provides the following methods to load
data:
•
Conventional path loads – construct
INSERT statements from the contents of the input data file based on the
predefined specification and execute the inserts.
•
Direct path loads – creates data
blocks in Oracle database block format from the data file and directly write the
data block to the database. This way is much faster than the conventional path
but subject to some restrictions.
•
External table loads – create
an external table for the data stored in the data file and execute INSERT statements
to insert the data from the data file into the target table. The external table
loads support parallel loading if data file is big enough.
To execute the SQL*Load tool, you need at least three
files:
•
The input data file stores delimited
or raw data
•
The parameter file stores the
location of the input/output files
•
The control file contains the
specification on how data is loaded.
No comments:
Post a Comment