Publisher: O'Reilly Media Released: April 2001 Pages: 272
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. |
-
Chapter 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 -
Chapter 2 The Mysterious Control File -
Syntax Rules -
The LOAD Statement -
Command-Line Parameters in the Control File -
Placing Data in the Control File -
Chapter 3 Fields and Datatypes -
Field Specifications -
Datatypes -
Chapter 4 Loading from Fixed-Width Files -
Common Datatypes Encountered -
Specifying Field Positions -
Handling Anomalous Data -
Concatenating Records -
Nesting Delimited Fields -
Chapter 5 Loading Delimited Data -
Common Datatypes Encountered -
Example Data -
Using Delimiters to Identify Fields -
Common Issues with Delimited Data -
Concatenating Records -
Handling Nested Fields -
Chapter 6 Recovering from Failure -
Deleting and Starting Over -
Restarting a Conventional Path Load -
Restarting a Direct Path Load -
Chapter 7 Validating and Selectively Loading Data -
Handling Rejected Records -
Selectively Loading Data -
Chapter 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 -
Chapter 9 Transaction Size and Performance Issues -
Transaction Processing in SQL*Loader -
Commit Frequency and Load Performance -
Commit Frequency and Rollback Segments -
Performance Improvement Guidelines -
Chapter 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 -
Chapter 11 Loading Large Objects -
About Large Objects -
Considerations when Loading LOBs -
Loading Inline LOBs -
Loading LOBs from External Data Files -
Loading BFILEs -
Chapter 12 Loading Objects and Collections -
Loading Object Tables and Columns -
Loading Collections -
Using NULLIF and DEFAULTIF with an Object or a Collection -
Colophon |
- Title:
- Oracle SQL*Loader: The Definitive Guide
- By:
- Jonathan Gennick, Sanjay Mishra
- Publisher:
- O'Reilly Media
- Formats:
-
- Print
- Ebook
- Safari Books Online
- Print:
- April 2001
- Ebook:
- June 2009
- Pages:
- 272
- Print ISBN:
- 978-1-56592-948-7
- | ISBN 10:
- 1-56592-948-9
- Ebook ISBN:
- 978-0-596-55982-3
- | ISBN 10:
- 0-596-55982-8
|
-
Jonathan Gennick 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 about it. Recent projects include Oracle SQLLoader (O'Reilly & Associates, 2001); Oracle SQLPlus Pocket Reference (O'Reilly & Associates, 2000); Oracle SQL*Plus: The Definitive Guide (O'Reilly & Associates, 1999); More recently, Jonathan has made forays into other database products, coauthoring Transact-SQL Cookbook (O'Reilly & Associates, 2002) and editing Practical PostgreSQL (O'Reilly & Associates, 2002). Jonathan is certified as an Oracle DBA and is a member of MENSA and the Oracle Technology Network. He holds a Bachelor of Arts degree in Information and Computer Science, with a Business Administration minor, from Andrews University in Berrien Springs, Michigan. Jonathan currently resides in Munising, Michigan with his wife Donna and their two children: Jenny and Jeff. Jonathan may be contacted by email at jonathan@gennick.com, and you can learn more about him personally by visiting his website at http://gennick.com. View Jonathan Gennick's full profile page. -
Sanjay Mishra Sanjay Mishra is a certified Oracle database administrator with more than ten years of IT experience. 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, 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 is the coauthor of Oracle Parallel Processing and Oracle SQL Loader: The Definitive Guide (both published by O'Reilly & Associates). Presently, he works as a database architect at Dallas Based i2 Technologies, and can be reached at sanjay_mishra@i2.com. View Sanjay Mishra's full profile page. |
Colophon Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animal on the cover of Oracle SQL*Loader: The Definitive Guide is a scarab beetle. There are nearly 30,000 members of the scarab beetle family, and over 1,200 in North America alone. This large, heavy-bodied beetle is classified in the order Coleoptera, family Scarabaeidae. Many scarab beetles are brightly colored, and some are iridescent. In North America, the largest scarabs are the Hercules beetle and the closely related elephant and rhinoceros beetles. The males of these species have prominent horns. Many scarabs are scavengers, living on decaying vegetation and animal dung. They are consider efficient recyclers and valuable for reducing disease-breeding waste. Some of the scavengers of the scarab family use their front legs to gather dung and roll it into a ball. They carry the ball underground and use it as food and a place to lay their eggs. The Mediterranean black scarab's apparently magical ability to reproduce from mud and decaying organic materials led the ancient Egyptians to associate the scarab with resurrection and immortality. The beetles were considered sacred, and representations in stone and metal were buried with mummies. A member of the North American scarab family plays a key role in Edgar Allen Poe's story "The Gold-Bug." In his search of Sullivan's Island, South Carolina, a scarab beetle is William Legrand's mysterious guide to the buried treasure of Captian Kidd. Colleen Gorman was the production editor and the copyeditor for Oracle SQL*Loader: The Definitive Guide. Sarah Jane Shangraw and Linley Dolby provided quality control, and Leanne Soylemez was the proofreader. John Bickelhaupt wrote the index. Ellie Volckhausen designed the cover of this book, based on a series design by Edie Freedman. The cover image is from Cuvier's Animals. Emma Colby produced the cover layout with QuarkXPress 4.1 using Adobe's ITC Garamond font. Melanie Wang designed the interior layout based on a series design by Nancy Priest. Anne-Marie Vaduva converted the files from Microsoft Word to FrameMaker 5.5.6 using tools created by Mike Sierra. The text and heading fonts are ITC Garamond Light and Garamond Book; the code font is Constant Willison. The illustrations that appear in the book were produced by Robert Romano and Jessamyn Read using Macromedia FreeHand 9 and Adobe Photoshop 6. This colophon was written by Colleen Gorman. |
|
Description
|
Table of Contents
|
Product Details
|
About the Author
|
Colophon
|
 |
|
 |
|
|
|
Recommended for You
|
Recently Viewed
|
 |
|
By Jesse Stay
July 2008
Ebook: $23.99
Print & Ebook: $32.99
Print: $29.99
By Dale Dougherty
November 1990
By Paul Robichaux, Missy Koslosky, Devin L. Ganger
June 2005
Ebook: $35.99
Print & Ebook: $49.45
Print: $44.95
|
Customer Reviews
3/2/2010 (0 of 1 customers found this review helpful) By [@]lgwheelloader [@] from CA
|
|
|