Over the years, Oracle has steadily enhanced SQL*Loader's capabilities and performance, making it an increasingly powerful tool for loading large volumes of data. The catch? This command-line utility is tough to learn -- and Oracle's documentation is confusing. Hence, many DBAs have barely scratched the surface with it -- and that's a shame.
Oracle SQL*Loader: The Definitive Guide to the rescue. Jonathan Gennick and Sanjay Mishra have plumbed the depths of SQL*Loader and lived to tell the tale -- which they do, with clarity, precision, and plenty of examples. For example, there's in-depth coverage of "the mysterious control file" that directs SQL*Loader's behavior. There are detailed chapters on loading from fixed-width files and delimited data sources, even loading large objects and collections.
There's a full chapter on recovering from failure: how to determine what was loaded, and restart from where things went awry. You'll learn how to selectively load data; validate and transform data as it loads; and tweak SQL*Loader to improve performance. Speaking of tweaking, there's a full chapter on direct path loads, which can supercharge performance by avoiding SQL processing bottlenecks.
Don't ignore SQL*Loader. Don't dread it. Make the most of it -- with this book.(Bill Camarda)
--Bill Camarda is a consultant, writer, and web/multimedia content developer with nearly 20 years' experience in helping technology companies deploy and market advanced products and services. He served for nearly ten years as vice president of a New Jersey-based marketing company, where he supervised a wide range of graphics and web design projects. His 15 books include Special Edition Using Word 2000