Part II SQL*Loader

Learn about SQL*Loader and its features, as well as data loading concepts, including object support.

• Understanding How to Use SQL*Loader
  Learn about the basic concepts you should understand before loading data into an Oracle Database using SQL*Loader.
• SQL*Loader Command-Line Reference
  To start regular SQL*Loader, use the command-line parameters.
• 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 with SQL*Loader
  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 provides the option to load data using a conventional path load method, and a direct path load method.
• SQL*Loader Express
  SQL*Loader express mode allows you to quickly and easily use SQL*Loader to load simple data types.