Oracle SQL*Loader: The Definitive Guide

BUY THIS BOOK

Print Book $34.95

PDF $27.99

Safari Books Online

What is this?

Print Book £24.95

What is this?

Looking to Reprint or License this content?

Tell a friend

Oracle SQL*Loader: The Definitive Guide

By Jonathan Gennick, Sanjay Mishra
First Edition April 2001
Pages: 272
ISBN 10: 1-56592-948-9 | ISBN 13: 9781565929487

Book description

Despite the wide availability and use of SQL*Loader, few Oracle DBAs and developers know how powerful it really is. This book describes all of SQL*Loader's functions, including how to construct the necessary control files, load different types of data, and get the best performance. It 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).
Full Description

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.

Post-purchase benefits:

Browse within this book

Cover | Table of Contents | Index | Sample Chapter | Colophon

Book details

First Edition: April 2001
ISBN: 1-56592-948-9
Pages: 272

Featured customer reviews

Be the first person to review this book!

Media reviews

"I started using this book about 1 month ago and knew nothing about SQL*Loader. This book has helped me be creative in the different ways that this utility can be used...The language and examples are clear, concise and easy to understand. It is a good book to refer to, for beginners as well as for experienced professionals. I've learned a lot from this book and so can others."
--Karen Gillingham, Williamsburg Macromedia User Group, August 2002

"5 birdies. Wow the title hits it bulls-eye--The Definitive Guide--A humongous effort went into the book and the examples. It’s another one for the desk, always to hand...Bravo Well Done."
--plomax@oriole.com, Oct 2001

"This is a must have for beginners and advanced users alike. Finally there is something out there that provides the information you need at your fingertips. If you find reading Oracle's White Pages confusing this book will help you understand, and how to most effectively use SQL Loader. I highly recommend this book." --Kevin Ware, Juno Beach User group, August 2001

Hide extended reviews