Jonathan Gennick

Jonathan Gennick

press my name for the menu

Writer * Book Editor * Oracle DBA * SQL & PL/SQL Developer

Father * Husband * Son * Mountain Biker * EMT

Oracle SQL*Loader: The Definitive Guide
Corrections

What follows is a compendium of all errors that I'm aware of in my book. All these errors may not be present in your copy. O'Reilly corrects known errors with each printing, so the more recently your book was printed, the fewer of these errors will apply.

Chapter 2: The Mysterious Control File

Page 30, The list item for INSERT | APPEND | REPLACE | TRUNCATE
In the description for this item, I recommend specifying this information at the table-level using the INFILE clause. It's actually the INTO TABLE clause that you would use for that purpose.

Chapter 10: Direct Path Loads

Page 186-187, "Storage Issues with Direct Path Load"
All the information under this heading applies only to parallel direct path loads. Note the word "parallel". None of what's under this heading applies to direct path loads that are not done in parallel. We apologize for not making that clear in the text.

Page 200 and others, "Use of sqlload instead of sqlldr"
Occasionally in the book, in particular in chapter 10, you'll see examples that use the command sqlload to invoke SQL*Loader. That is a mistake. The correct command to use is sqlldr.