Oracle SQL*Loader: The Definitive Guide
Customer Reviews: 1 Average Customer Rating:  Write a Review and tell the world about this title! People who purchase this book frequently purchase: - Oracle PL/SQL Programming, 4th Edition; Steven Feuerstein, et al, $38.95, 40% Off!
- Oracle SQL*Plus: The Definitive Guide, 2nd Edition; Jonathan Gennick, $23.95, 40% Off!
- Oracle Database 10g: The Complete Reference; Kevin Loney, $44.95, 39% Off!
- Mastering Oracle SQL, 2nd Edition; Sanjay Mishra, et al, $23.95, 40% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
Untitled Document
Despite the wide availability and use of SQL*Loader, few Oracle DBAs and developers
know how powerful it really is. This book describes all of SQL*Loader's functions,
including how to construct the necessary control files, load different types
of data, and get the best performance. It covers the newest SQL*Loader features--the
loading of large object (LOB) columns and the new object types (nested tables,
varying arrays, and object tables).
Table of Contents
Preface
1. Introduction to SQL*Loader
The SQL*Loader Environment
A Short SQL*Loader Example
SQL*Loader's Capabilities
Issues when Loading Data
Invoking SQL*Loader
2. The Mysterious Control File
Syntax Rules
The LOAD Statement
Command-Line Parameters in the Control File
Placing Data in the Control File
3. Fields and Datatypes
Field Specifications
Datatypes
4. Loading from Fixed-Width Files
Common Datatypes Encountered
Specifying Field Positions
Handling Anomalous Data
Concatenating Records
Nesting Delimited Fields
5. Loading Delimited Data
Common Datatypes Encountered
Example Data
Using Delimiters to Identify Fields
Common Issues with Delimited Data
Concatenating Records
Handling Nested Fields
6. Recovering from Failure
Deleting and Starting Over
Restarting a Conventional Path Load
Restarting a Direct Path Load
7. Validating and Selectively Loading Data
Handling Rejected Records
Selectively Loading Data
8. Transforming Data During a Load
Using Oracle's Built-in SQL Functions
Writing Your Own Functions
Passing Data Through Work Tables
Using Triggers
Performing Character Set Conversion
9. Transaction Size and Performance Issues
Transaction Processing in SQL*Loader
Commit Frequency and Load Performance
Commit Frequency and Rollback Segments
Performance Improvement Guidelines
10. Direct Path Loads
What is the Direct Path?
Performing Direct Path Loads
Data Saves
Loading Data Fields Greater than 64K
UNRECOVERABLE Loads
Parallel Data Loading
11. Loading Large Objects
About Large Objects
Considerations when Loading LOBs
Loading Inline LOBs
Loading LOBs from External Data Files
Loading BFILEs
12. Loading Objects and Collections
Loading Object Tables and Columns
Loading Collections
Using NULLIF and DEFAULTIF with an Object or a Collection
Index
Customer Reviews
Customer Reviews: 1 Average Customer Rating: Sep 8, 2007 Scot from Jacksonville
I know it is old, but
I got this book way back not long after it was published. It was possibly my first Oracle book. We had to load very large volumes of data on a regular basis, and found this book to be a tremendous resource for us at the time. I don't know if more recent books cover the same information or not, because I haven't needed to worry about it; this one went into such excellent detail on pretty much every aspect of sql loader.
|
