Book description
SQLLoader is a ubiquitous tool in the Oracle world. It has been shipped with Oracle since at least Version 6 and continues to be supported and enhanced with each new version of Oracle, including Oracle8 and Oracle8i. The job of SQLLoader is to load data from flat files into an Oracle database. It's optimized for loading large volumes of data, and is flexible enough to handle virtually any input format.Almost every Oracle user has to use SQLLoader at one time or another, and DBAs are frequently called upon to load data for the users in their organization. Despite SQLLoader's wide availability and usage, few DBAs and developers know how to get the most out of it. Oracle SQLLoader: The Definitive Guide has everything you need to know to put SQLLoader to its best use: an introduction to SQLLoader, a reference to all of its syntax options, and most importantly, step-by-step instructions for all the SQLLoader 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 SQLLoader performance by adjusting the transaction size and using the new direct path option. It also covers the newest SQLLoader features--the loading of large object (LOB) columns and the new object types (nested tables, varying arrays, and object tables).Oracle SQLLoader: The Definitive Guide is an indispensable resource for anyone who is new to SQLLoader; 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.
Publisher resources
Table of contents
- Copyright
- Dedication
- A Note Regarding Supplemental Files
- Preface
- 1. Introduction to SQL*Loader
- 2. The Mysterious Control File
- 3. Fields and Datatypes
- 4. Loading from Fixed-Width Files
-
5. Loading Delimited Data
- 5.1. Common Datatypes Encountered
- 5.2. Example Data
- 5.3. Using Delimiters to Identify Fields
- 5.4. Common Issues with Delimited Data
- 5.5. Concatenating Records
- 5.6. Handling Nested Fields
- 6. Recovering from Failure
- 7. Validating and Selectively Loading Data
- 8. Transforming Data During a Load
- 9. Transaction Size and Performance Issues
-
10. Direct Path Loads
- 10.1. What is the Direct Path?
-
10.2. Performing Direct Path Loads
- 10.2.1. Preparing to Use Direct Path Loads
- 10.2.2. Invoking a Direct Path Load
- 10.2.3. Restrictions on Direct Path Loads
- 10.2.4. Storage Issues with Parallel Direct Path Load
- 10.2.5. Index Maintenance with Direct Path Loads
- 10.2.6. Direct Path Loads and Integrity Constraints
- 10.2.7. Direct Path Loads and Database Triggers
- 10.3. Data Saves
- 10.4. Loading Data Fields Greater than 64K
- 10.5. UNRECOVERABLE Loads
- 10.6. Parallel Data Loading
- 11. Loading Large Objects
- 12. Loading Objects and Collections
- About the Authors
- Colophon
- Copyright
Product information
- Title: Oracle SQL*Loader: The Definitive Guide
- Author(s):
- Release date: April 2001
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781565929487
You might also like
book
Oracle SQL: the Essential Reference
SQL (Structured Query Language) is the heart of a relational database management system. It's the language …
book
Oracle Built-in Packages
Oracle is the most popular database management system in use today, and PL/SQL plays a pivotal …
book
Oracle SQL*Plus: The Definitive Guide
This book is the definitive guide to SQL*Plus. If you want to take best advantage of …
book
Oracle in a Nutshell
Introduced a quarter-century ago, the Oracle database remains the leading enterprise relational database management system (RDBMS) …