SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK ORACLE SQLLOADER THE DEFINITIVE GUIDE
SUMMARY
-
Items Found: 63
- 1. Introduction to SQL*Loader 1
- The SQL*Loader Environment 2
- A Short SQL*Loader Example 4
- SQL*Loader’s Capabilities 11
- Issues when Loading Data 11
- Invoking SQL*Loader 14
- 2. The Mysterious Control File 22
- Syntax Rules 22
- The LOAD Statement 28
- Command-Line Parameters in the Control File 43
- Placing Data in the Control File 45
- 3. Fields and Datatypes 47
- Field Specifications 47
- Datatypes 59
- 4. Loading from Fixed-Width Files 78
- Common Datatypes Encountered 79
- Specifying Field Positions 79
- Handling Anomalous Data 83
- Concatenating Records 96
- Nesting Delimited Fields 103
- 5. Loading Delimited Data 107
- Common Datatypes Encountered 107
- Example Data 108
- Using Delimiters to Identify Fields 108
- Common Issues with Delimited Data 118
- Concatenating Records 124
- Handling Nested Fields 127
- 6. Recovering from Failure 130
- Deleting and Starting Over 131
- Restarting a Conventional Path Load 132
- Restarting a Direct Path Load 136
- 7. Validating and Selectively Loading Data 141
- Handling Rejected Records 141
- Selectively Loading Data 146
- 8. Transforming Data During a Load 152
- Using Oracle’s Built-in SQL Functions 152
- Writing Your Own Functions 156
- Passing Data Through Work Tables 158
- Using Triggers 159
- Performing Character Set Conversion 161
- 9. Transaction Size and Performance Issues 167
- Transaction Processing in SQL*Loader 167
- Commit Frequency and Load Performance 168
- Commit Frequency and Rollback Segments 175
- Performance Improvement Guidelines 179
- 10. Direct Path Loads 182
- What is the Direct Path? 182
- Performing Direct Path Loads 184
- Data Saves 196
- Loading Data Fields Greater than 64K 197
- UNRECOVERABLE Loads 198
- Parallel Data Loading 199
- 11. Loading Large Objects 205
- About Large Objects 205
- Considerations when Loading LOBs 208
- Loading Inline LOBs 210
- Loading LOBs from External Data Files 212
- Loading BFILEs 217
- 12. Loading Objects and Collections 221
- Loading Object Tables and Columns 221
- Loading Collections 225
- Using NULLIF and DEFAULTIF with an Object or a Collection 240
- Index 243
