UNDERSTANDING SQL LOADER

Understanding SQL Loader#

SQL Loader is a utility created by Oracle and installed onto the database server during the installation of the software, as well as a large number of other programs. SQL Loader loads data in a variety of formats, performs filtering (selectively loading records based upon the data values), and loads multiple tables simultaneously. During execution, SQL Loader produces a detailed log file with statistics about the load. It may also produce a bad file (containing records rejected because of incorrect data) and a discard file (containing records that did not meet the specified selection criteria).

SQL Loader can:

Data to be loaded into the Oracle database must exist in files on disk. These data files require mapping (translation to Oracle format) to be loaded by SQL Loader. You specify how SQL Loader interprets the data via data definitions contained in control files. The control file also is the repository for certain file management information.


Notes #

Click to create a new notes page