Oracle7 Server Utilities

PART II . SQL*Loader

Part II explains how to use SQL*Loader, a utility for loading data from external files into Oracle database tables. SQL*Loader processes a wide variety of input file formats and gives you control over how records are loaded into Oracle tables.

If you have never used a data loading product, begin by reading the introduction and then examine the case studies provided. These two chapters provide a good introduction to data loading concepts.

If you are comfortable with data loading concepts, you may want to start with the examples and then consult Chapters 5 and 6 for detailed reference information on SQL*Loader.

The following topics are covered:

overview of SQL*Loader functionality (Chapter 3)

case studies of SQL*Loader in action (Chapter 4)

control file reference (Chapter 5)

command-line reference (Chapter 6)

log file reference (Chapter 7)

using the direct path for high-performance loads (Chapter 8)