Oracle SQL*Loader: The Definitive Guide

The Definitive Guide

Do you like this document?

Notes

Please login to add notes

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 Oracle8_i._ 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 SQLLoader 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 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.

Page_place_entryicon_cmyk_1201111
Uvk
Oreilly-media-logo3
Packtpublishing

Test the closed alpha on paperc.com

Book Details

Authors

Jonathan Gennick and Sanjay Mishra

Categories

Computers > Database Management > General

Publishers

O'Reilly Media

Publication year : 2008

License: All rights reserved ©

Times read: 801

Share book page

My Annotations