Sumário Itens Encontrados: 63Index 243Using NULLIF and DEFAULTIF with an Object or a Collection 240Loading Collections 225Loading Object Tables and Columns 22112. Loading Objects and Collections 221Loading BFILEs 217Loading LOBs from External Data Files 212Loading Inline LOBs 210Considerations when Loading LOBs 208About Large Objects 20511. Loading Large Objects 205Parallel Data Loading 199UNRECOVERABLE Loads 198Loading Data Fields Greater than 64K 197Data Saves 196Performing Direct Path Loads 184What is the Direct Path? 18210. Direct Path Loads 182Performance Improvement Guidelines 179Commit Frequency and Rollback Segments 175Commit Frequency and Load Performance 168Transaction Processing in SQL*Loader 1679. Transaction Size and Performance Issues 167Performing Character Set Conversion 161Using Triggers 159Passing Data Through Work Tables 158Writing Your Own Functions 156Using Oracleâs Built-in SQL Functions 1528. Transforming Data During a Load 152Selectively Loading Data 146Handling Rejected Records 1417. Validating and Selectively Loading Data 141Restarting a Direct Path Load 136Restarting a Conventional Path Load 132Deleting and Starting Over 1316. Recovering from Failure 130Handling Nested Fields 127Concatenating Records 124Common Issues with Delimited Data 118Using Delimiters to Identify Fields 108Example Data 108Common Datatypes Encountered 1075. Loading Delimited Data 107Nesting Delimited Fields 103Concatenating Records 96Handling Anomalous Data 83Specifying Field Positions 79Common Datatypes Encountered 794. Loading from Fixed-Width Files 78Datatypes 59Field Specifications 473. Fields and Datatypes 47Placing Data in the Control File 45Command-Line Parameters in the Control File 43The LOAD Statement 28Syntax Rules 222. The Mysterious Control File 22Invoking SQL*Loader 14Issues when Loading Data 11SQL*Loaderâs Capabilities 11A Short SQL*Loader Example 4The SQL*Loader Environment 21. Introduction to SQL*Loader 1