Item Details

Oracle SQL*Loader: The Definitive Guide

Jonathan Gennick and Sanjay Mishra
Format
Book
Published
Beijing ; Cambridge : O'Reilly, 2001.
Language
English
ISBN
1565929489
Contents
  • 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. Mysterious Control File 22
  • Syntax Rules 22
  • 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
  • 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.
Description
xvii, 251 p. : ill. ; 24 cm.
Notes
Includes index.
Technical Details
  • Access in Virgo Classic

  • LEADER 03131nam a2200313Ia 4500
    001 u3728719
    003 SIRSI
    005 20010807140833.0
    008 010531s2001 enk 001 0 eng d
    020
      
      
    a| 1565929489
    035
      
      
    a| (Sirsi) i1565929489
    035
      
      
    a| (OCoLC)47043834
    040
      
      
    a| SCA c| SCA d| MvI
    090
      
      
    a| QA76.73.S67 b| G46 2001
    100
    1
      
    a| Gennick, Jonathan.
    245
    1
    0
    a| Oracle SQL*Loader : b| the definitive guide / c| Jonathan Gennick and Sanjay Mishra.
    260
      
      
    a| Beijing ; a| Cambridge : b| O'Reilly, c| 2001.
    300
      
      
    a| xvii, 251 p. : b| ill. ; c| 24 cm.
    504
      
      
    a| Includes index.
    505
    0
    0
    t| SQL* Loader Environment g| 2 -- t| A Short SQL* Loader Example g| 4 -- t| SQL* Loader's Capabilities g| 11 -- t| Issues when Loading Data g| 11 -- t| Invoking SQL* Loader g| 14 -- g| 2. t| Mysterious Control File g| 22 -- t| Syntax Rules g| 22 -- t| LOAD Statement g| 28 -- t| Command-Line Parameters in the Control File g| 43 -- t| Placing Data in the Control File g| 45 -- g| 3. t| Fields and Datatypes g| 47 -- t| Field Specifications g| 47 -- t| Datatypes g| 59 -- g| 4. t| Loading from Fixed-Width Files g| 78 -- t| Common Datatypes Encountered g| 79 -- t| Specifying Field Positions g| 79 -- t| Handling Anomalous Data g| 83 -- t| Concatenating Records g| 96 -- t| Nesting Delimited Fields g| 103 -- g| 5. t| Loading Delimited Data g| 107 -- t| Common Datatypes Encountered g| 107 -- t| Example Data g| 108 -- t| Using Delimiters to Identify Fields g| 108 -- t| Common Issues with Delimited Data g| 118 -- t| Concatenating Records g| 124 -- t| Handling Nested Fields g| 127 -- g| 6. t| Recovering from Failure g| 130 -- t| Deleting and Starting Over g| 131 -- t| Restarting a Conventional Path Load g| 132 -- t| Restarting a Direct Path Load g| 136 -- g| 7. t| Validating and Selectively Loading Data g| 141 -- t| Handling Rejected Records g| 141 -- t| Selectively Loading Data g| 146 -- g| 8. t| Transforming Data During a Load g| 152 -- t| Using Oracle's Built-in SQL Functions g| 152 -- t| Writing Your Own Functions g| 156 -- t| Passing Data Through Work Tables g| 158 -- t| Using Triggers g| 159 -- t| Performing Character Set Conversion g| 161 -- g| 9. t| Transaction Size and Performance Issues g| 167 -- t| Transaction Processing in SQL* Loader g| 167 -- t| Commit Frequency and Load Performance g| 168 -- t| Commit Frequency and Rollback Segments g| 175 -- t| Performance Improvement Guidelines g| 179 -- g| 10. t| Direct Path Loads g| 182 -- t| Performing Direct Path Loads g| 184 -- t| Data Saves g| 196 -- t| Loading Data Fields Greater than 64K g| 197 -- t| UNRECOVERABLE Loads g| 198 -- t| Parallel Data Loading g| 199 -- g| 11. t| Loading Large Objects g| 205 -- t| About Large Objects g| 205 -- t| Considerations when Loading LOBs g| 208 -- t| Loading Inline LOBs g| 210 -- t| Loading LOBs from External Data Files g| 212 -- t| Loading BFILEs g| 217 -- g| 12. t| Loading Objects and Collections g| 221 -- t| Loading Object Tables and Columns g| 221 -- t| Loading Collections g| 225 -- t| Using NULLIF and DEFAULTIF with an Object or a Collection g| 240.
    596
      
      
    a| 5
    630
    0
    0
    a| Oracle (Computer file)
    650
      
    0
    a| SQL (Computer program language)
    650
      
    0
    a| Database management.
    700
    1
      
    a| Mishra, Sanjay.
    994
      
      
    a| Z0 b| VA@
    999
      
      
    a| QA76.73 .S67 G46 2001 w| LC i| X004526291 l| STACKS m| SCI-ENG t| BOOK

Availability

Google Preview

Library Location Map Availability Call Number
Brown Science and Engineering Stacks N/A Available