Skip to content

Oracle SQL*Loader: the Definitive Guide The Definitive Guide

Best in textbook rentals since 2012!

ISBN-10: 1565929489

ISBN-13: 9781565929487

Edition: 2001

Authors: Jonathan Gennick, Sanjay Mishra, Debby Russell

List price: $39.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

SQL*Loader 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 Oracle8"i. The job of SQL*Loader 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 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:…    
Customers also bought

Book details

List price: $39.99
Copyright year: 2001
Publisher: O'Reilly Media, Incorporated
Publication date: 5/15/2001
Binding: Paperback
Pages: 274
Size: 6.75" wide x 9.00" long x 0.75" tall
Weight: 0.946
Language: English

Jonathan Gennick is an O'Reilly & Associates editor specializing in database and programming titles. Prior to joining O'Reilly, Jonathan amassed some 17 years of programming and database management experience. During the latter part of his career he specialized in relational database programming, and more recently in database management. Jonathan got his start with relational database systems in 1990, first working with Ingres, and later with Digital's Rdb software. During that period he developed a fondness for SQL, and for the challenge of applying SQL creatively in ways that leveraged it's set-oriented capabilities. In 1994 Jonathan made the leap to Oracle, and is now often found writing…    

Sanjay Mishra has more than 12 years of experience working with Oracle systems. His key areas of interest include database architecture, database administration, performance management, scalability, software development and data modelling for mission-critical and decision support applications. He holds a Bachelor of Science degree in Electrical Engineering, and a Master of Engineering degree in Systems Science and Automation. He is the co-author of the books Oracle Parallel Processing and Oracle SQL Loader: The Definitive Guide (both published by O'Reilly Media, Inc.). Sanjay has published several technical papers in Oracle Magazine and SELECT Journal, and has presented many technical…    

Preface
Introduction to SQL* Loader
The SQL* Loader Environment
A Short SQL* Loader Example
SQL* Loader's Capabilities
Issues when Loading Data
Invoking SQL* Loader
The Mysterious Control File
Syntax Rules
The LOAD Statement
Command-Line Parameters in the Control File
Placing Data in the Control File
Fields and Datatypes
Field Specifications
Datatypes
Loading from Fixed-Width Files
Common Datatypes Encountered
Specifying Field Positions
Handling Anomalous Data
Concatenating Records
Nesting Delimited Fields
Loading Delimited Data
Common Datatypes Encountered
Example Data
Using Delimiters to Identify Fields
Common Issues with Delimited Data
Concatenating Records
Handling Nested Fields
Recovering from Failure
Deleting and Starting Over
Restarting a Conventional Path Load
Restarting a Direct Path Load
Validating and Selectively Loading Data
Handling Rejected Records
Selectively Loading Data
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
Transaction Size and Performance Issues
Transaction Processing in SQL* Loader
Commit Frequency and Load Performance
Commit Frequency and Rollback Segments
Performance Improvement Guidelines
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
Loading Large Objects
About Large Objects
Considerations when Loading LOBs
Loading Inline LOBs
Loading LOBs from External Data Files
Loading BFILEs
Loading Objects and Collections
Loading Object Tables and Columns
Loading Collections
Using NULLIF and DEFAULTIF with an Object or a Collection
Index