Oracle SQL*Loader: The Definitive Guide

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 in 2001 - the loading of large object (LOB) columns and the new object types (nested tables, varying arrays, and object tables).

Jonathan Gennick is a writer and editor. His writing career began in 1997 when he coauthored Teach Yourself PL/SQL in 21 Days. Since then, he has written several O'Reilly books, including Oracle SQL*Plus: The Definitive Guide, Oracle SQL*Plus Pocket Reference, and Oracle Net8 Configuration and Troubleshooting. He has also edited a number of books for O'Reilly and other publishers, and he recently joined O'Reilly as an associate editor, specializing in Oracle books. Jonathan was formerly a manager in KPMG's Public Services Systems Integration practice, where he was also the lead database administrator for the utilities group working out of KPMG's Detroit office. He has more than a decade of experience with relational databases. Jonathan is a member of MENSA, and he holds a bachelor of arts degree in information and computer science from Andrews University in Berrien Springs, Michigan. He currently resides in Munising, Michigan, with his wife Donna and their two children: twelve- year-old Jenny, who often wishes her father wouldn't spend quite so much time writing, and five-year-old Jeff, who has never seen it any other way. Sanjay Mishra is a certified Oracle database administrator with more than nine years of IT experience. For the past six years, he has been involved in the design, architecture, and implementation of many mission-critical and decision support databases. He has worked extensively in the areas of database architecture, database management, backup/recovery, disaster planning, performance tuning, Oracle Parallel Server, and parallel execution. he has a bachelor of science degree in electrical engineering and a master of engineering in systems science and automation. He is the coauthor of Oracle Parallel Processing (O'Reilly & Associates, 2000) and can be reached at sanjay_mishra@i2.com.