| |
SQL*Loader 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 SQL*Loader 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 SQL*Loader at one time or another, and DBAs are frequently called upon to load data for the users in their organization. Despite SQL*Loader\`s wide availability and usage, few DBAs and developers know how to get the most out of it. Oracle SQL*Loader: The Definitive Guide has everything you need to know to put SQL*Loader to its best use: an introduction to SQL*Loader, a reference to all of its syntax options, and most importantly, step-by-step instructions for all the SQL*Loader 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 SQL*Loader 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 SQL*Loader: The Definitive Guide is an indispensable resource for anyone who is new to SQL*Loader; 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.
ISBN 9788173663635
|
| |
Pages : 278
|