Oracle Sql Loader
The Definitive Guide
Jonathan Gennick, Sanjay Mishra
Résumé
Almost every Oracle user has to use SQL*Loader at one time or another, and DBAs are frequently called upon to load data for the users in their organization. Despite SQL*Loader's wide availability and usage, few DBAs and developers know how to get the most out of it. Oracle SQL*Loader: The Definitive Guide has everything you need to know to put SQL*Loader to its best use: an introduction to SQL*Loader, a reference to all of its syntax options, and most importantly, step-by-step instructions for all the SQL*Loader tasks you'd want to perform—and maybe some you didn't realize you COULD perform.
You'll learn how to construct the necessary control files and load from different types of files containing different types of data (e.g., fixed-width data, delimited data, and data of various datatypes). You'll also learn how to validate data, load it selectively, transform it as it is loaded, and recover after failure. This book explains how to optimize SQL*Loader performance by adjusting the transaction size and using the new direct path option. It also 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).
Oracle SQL*Loader: TheDefinitive Guide is an indispensable resource for anyone who is new to SQL*Loader; a task-oriented learning tool for those who are already using it; and a quick reference for every user. If you want to take best advantage of an essential Oracle tool, you need this book.
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
L'auteur - Jonathan Gennick
Jonathan Gennick est administrateur de base de données
Oracle. Il est aussi écrivain et éditeur. Il est l'auteur
de Oracle SQL*Plus : The Definitive Guide, dont proviennent
les informations de ce guide, et de plusieurs autres
ouvrages sur Oracle.
L'auteur - Sanjay Mishra
Sanjay Mishra is a certified Oracle database
administrator with more than nine
years of IT experience. For the past six years, he has been
involved in the design,
architecture, and implementation of many mission-critical
and decision support
databases. He has worked extensively in the areas of
database architecture, database
management, backup/recovery, disaster planning, performance
tuning, Oracle Parallel
Server, and parallel execution. He has a bachelor of
science degree in electrical
engineering and a master of engineering degree in systems
science and automation. He
can be reached at sanjay_mishra@i2.com.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | O'Reilly |
| Auteur(s) | Jonathan Gennick, Sanjay Mishra |
| Parution | 01/05/2001 |
| Nb. de pages | 251 |
| Format | 17,7 x 23,3 |
| Couverture | Broché |
| Poids | 447g |
| Intérieur | Noir et Blanc |
| EAN13 | 9781565929487 |
| ISBN13 | 978-1-56592-948-7 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
