Oracle Sql*loader: The Definitive Guide

by Jonathan Gennick and Sanjay Mishra

Book Overview

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...

• Format: Paperback
• Language: English
• ISBN: 1565929489
• ISBN13: 9781565929487
• Release Date: May 2001
• Publisher: O'Reilly Media
• Length: 272 Pages
• Weight: 0.97 lbs.
• Dimensions: 0.7" x 7.0" x 9.2"

Customer Reviews

No Bull straight to the point

I have been dealing with databases for over three years now. Right now I am doing Siebel Consulting in which Enterprise Integration Module(EIM) is responsible for data transfer from any source to Sieble database. I came across a requirement where I had to use Oracle SQL Loader, so I went looking for a good book. This 250 page book tells you everything you need to know about SQL Loader in less time than any other. Lots of code and real time examples. Worth having as ref book for all DBAs or even developers. Five Stars for sure.

Comprehensive info on SQL Loader all in one place

I searched through several manuals and guides on Oracle only to discover that very few cover the SQL Loader tool in great detail. This book does so, and in a way that's fairly easy to read. It is a huge benefit over the sparse 2-3 pages of documentation you'll typically find elsewhere.

Comprehensive reference

Useful for both new and experienced Oracle DBAs and developers. Initially, some co-workers scoffed, saying that the topic of SQL Loader does not need an entire book on the subject. However, after they looked at my copy, they changed their minds, and wanted to borrow it.

Sql ldr

Very good book on SQL loader. Eveything is in one place and easy to find. Answered all my questions and I got a few ideas about other ways to use SQL loader.

Clearly information collected into one handy reference

Although Oracle does a reasonable job of clearly explaining SQL*Loader, this guide takes it a giant leap forward. First it collects everything you ever needed or wanted to know about SQL*Loader into a 251 page reference. It's written in a friendlier fashion than Oracle's documentation, and with more examples that are better written. On the whole, this promotes a better understanding of SQL*Loader, its strengths and limitations, and will allow DBAs to master every facet and nuance of this powerful tool. Considering the damage that can be inflicted on a production database if SQL*Loader is improperly used, all DBAs who use this tool to load data (and who doesn't?) should read this book and have a copy on their desk.Another use for this book is as a training aid for new DBAs and as the basis for database administration policies and procedures that spell out when and how to load data into a production system. It also contains a wealth of information that can be incorporated into change control implementation and rollback plans when massive updates need to be performed. I like the thorough treatment, the fact that it's up-to-date, and the advice and tips that are imparted throughout this book. It's definitely a good addition to your professional library.