Oracle SQL*Loader: The Definitive Guide
Oracle SQL*Loader: The Definitive Guide By Jonathan Gennick, Sanjay Mishra
April 2001
Pages: 272

| Table of Contents | Index | Sample Chapter | Colophon

Table of Contents

  1. Chapter 1 Introduction to SQL*Loader

    1. The SQL*Loader Environment

    2. A Short SQL*Loader Example

    3. SQL*Loader's Capabilities

    4. Issues when Loading Data

    5. Invoking SQL*Loader

  2. Chapter 2 The Mysterious Control File

    1. Syntax Rules

    2. The LOAD Statement

    3. Command-Line Parameters in the Control File

    4. Placing Data in the Control File

  3. Chapter 3 Fields and Datatypes

    1. Field Specifications

    2. Datatypes

  4. Chapter 4 Loading from Fixed-Width Files

    1. Common Datatypes Encountered

    2. Specifying Field Positions

    3. Handling Anomalous Data

    4. Concatenating Records

    5. Nesting Delimited Fields

  5. Chapter 5 Loading Delimited Data

    1. Common Datatypes Encountered

    2. Example Data

    3. Using Delimiters to Identify Fields

    4. Common Issues with Delimited Data

    5. Concatenating Records

    6. Handling Nested Fields

  6. Chapter 6 Recovering from Failure

    1. Deleting and Starting Over

    2. Restarting a Conventional Path Load

    3. Restarting a Direct Path Load

  7. Chapter 7 Validating and Selectively Loading Data

    1. Handling Rejected Records

    2. Selectively Loading Data

  8. Chapter 8 Transforming Data During a Load

    1. Using Oracle's Built-in SQL Functions

    2. Writing Your Own Functions

    3. Passing Data Through Work Tables

    4. Using Triggers

    5. Performing Character Set Conversion

  9. Chapter 9 Transaction Size and Performance Issues

    1. Transaction Processing in SQL*Loader

    2. Commit Frequency and Load Performance

    3. Commit Frequency and Rollback Segments

    4. Performance Improvement Guidelines

  10. Chapter 10 Direct Path Loads

    1. What is the Direct Path?

    2. Performing Direct Path Loads

    3. Data Saves

    4. Loading Data Fields Greater than 64K

    5. UNRECOVERABLE Loads

    6. Parallel Data Loading

  11. Chapter 11 Loading Large Objects

    1. About Large Objects

    2. Considerations when Loading LOBs

    3. Loading Inline LOBs

    4. Loading LOBs from External Data Files

    5. Loading BFILEs

  12. Chapter 12 Loading Objects and Collections

    1. Loading Object Tables and Columns

    2. Loading Collections

    3. Using NULLIF and DEFAULTIF with an Object or a Collection

  1. Colophon

Return to Oracle SQL*Loader: The Definitive Guide