9 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. Successfully using a SQL*Loader control file requires an understanding of the following topics:

• Control File Contents

• Specifying Command-Line Parameters in the Control File

• Specifying File Names and Object Names

• Identifying XMLType Tables

• Specifying Field Order

• Specifying Data Files

• Specifying CSV Format Files

• Identifying Data in the Control File with BEGINDATA

• Specifying Data File Format and Buffering

• Specifying the Bad File

• Specifying the Discard File

• Specifying a NULLIF Clause At the Table Level

• Specifying Datetime Formats At the Table Level

• Handling Different Character Encoding Schemes

• Interrupted Loads

• Assembling Logical Records from Physical Records

• Loading Logical Records into Tables

• Index Options

• Benefits of Using Multiple INTO TABLE Clauses

• Bind Arrays and Conventional Path Loads