Part II SQL*Loader
Following are topics about the SQL*Loader utility.
Describes SQL*Loader and its features, as well as data loading concepts (including object support). It discusses input to SQL*Loader, database preparation, and output from SQL*Loader.
SQL*Loader Command-Line Reference
Describes the command-line syntax used by SQL*Loader. It discusses command-line arguments, suppressing SQL*Loader messages, sizing the bind array, and more.
SQL*Loader Control File Reference
Describes the control file syntax you use to configure SQL*Loader and to describe to SQL*Loader how to map your data to Oracle format. It provides detailed syntax diagrams and information about specifying data files, tables and columns, the location of data, the type and format of data to be loaded, and more.
SQL*Loader Field List Reference
Describes the field list section of a SQL*Loader control file. The field list provides information about fields being loaded, such as position, data type, conditions, and delimiters.
Loading Objects, LOBs, and Collections
Describes how to load column objects in various formats. It also discusses how to load object tables,
REF columns, LOBs, and collections.
Conventional and Direct Path Loads
Describes the differences between a conventional path load and a direct path load. A direct path load is a high-performance option that significantly reduces the time required to load large quantities of data.
Describes SQL*Loader express mode, which allows you to quickly and easily load simple data types.
- SQL*Loader Concepts
These sections describe SQL*Loader concepts.
- SQL*Loader Command-Line Reference
You can use command-line parameters to start SQL*Loader.
- SQL*Loader Control File Reference
The SQL*Loader control file is a text file that contains data definition language (DDL) instructions for a SQL*Loader job.
- SQL*Loader Field List Reference
The field-list portion of a SQL*Loader control file provides information about fields being loaded, such as position, data type, conditions, and delimiters.
- Loading Objects, LOBs, and Collections
You can use SQL*Loader to load column objects in various formats and to load object tables, REF columns, LOBs, and collections.
- Conventional and Direct Path Loads
- SQL*Loader Express