2. The Mysterious Control File 22 -- 3. Fields and Datatypes 47 -- 4. Loading from Fixed-Width Files 78 -- 5. Loading Delimited Data 107 -- 6. Recovering from Failure 130 -- 7. Validating and Selectively Loading Data 141 -- 8. Transforming Data During a Load 152 -- 9. Transaction Size and Performance Issues 167 -- 10. Direct Path Loads 182 -- 11. Loading Large Objects 205 -- 12. Loading Objects and Collections 221
Summary
SQLLoader 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 SQLLoader 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 SQLLoader at one time or another, and DBAs are frequently called upon to load data for the users in their organization. Despite SQLLoader's wide availabilit
