SQLLoader is a ubiquitous tool in the Oracle world. It has been shipped
with Oracle since at least Version 6 and continues to be supported and
enhanced with each new version of Oracle, including Oracle8 and
Oracle8i.* The job of SQLLoader is to load data from flat files into
an Oracle database. It's optimized for loading large volumes of data,
and is flexible enough to handle virtually any input format.Almost every
Oracle user has to use SQLLoader at one time or another, and DBAs are
frequently called upon to load data for the users in their organization.
Despite SQLLoader's wide availability and usage, few DBAs and
developers know how to get the most out of it. Oracle SQLLoader: The
Definitive Guide** has everything you need to know to put SQLLoader to
its best use: an introduction to SQLLoader, a reference to all of its
syntax options, and most importantly, step-by-step instructions for all
the SQLLoader tasks you'd want to perform--and maybe some you didn't
realize you COULD perform.You'll learn how to construct the necessary
control files and load from different types of files containing
different types of data (e.g., fixed-width data, delimited data, and
data of various datatypes). You'll also learn how to validate data, load
it selectively, transform it as it is loaded, and recover after failure.
This book explains how to optimize SQLLoader performance by adjusting
the transaction size and using the new direct path option. It also
covers the newest SQL*Loader features--the loading of large object (LOB)
columns and the new object types (nested tables, varying arrays, and
object tables).Oracle SQLLoader: The Definitive Guide** is an
indispensable resource for anyone who is new to SQLLoader; a
task-oriented learning tool for those who are already using it; and a
quick reference for every user. If you want to take best advantage of an
essential Oracle tool, you need this book.
