Oracle SQL*Loader

The Definitive Guide: Loading Data into an Oracle Database

Johnathan Gennick & Sanjay Mishra, Sanjay Mishra

$76

Book

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

O'Reilly Media
10 May 2001

Database programming; Oracle

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 in 2001 - the loading of large object (LOB) columns and the new object types (nested tables, varying arrays, and object tables).

By: Johnathan Gennick & Sanjay Mishra
Contributions by: Sanjay Mishra
Imprint: O'Reilly Media
Country of Publication: United States
Dimensions: Height: 232mm, Width: 178mm, Spine: 19mm
Weight: 430g
ISBN: 9781565929487
ISBN 10: 1565929489
Pages: 250
Publication Date: 10 May 2001
Audience: Professional and scholarly , General/trade , Undergraduate , ELT Advanced
Format: Book
Publisher's Status: Active

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

Jonathan Gennick is a writer and editor. His writing career began in 1997 when he coauthored Teach Yourself PL/SQL in 21 Days. Since then, he has written several O'Reilly books, including Oracle SQL*Plus: The Definitive Guide, Oracle SQL*Plus Pocket Reference, and Oracle Net8 Configuration and Troubleshooting. He has also edited a number of books for O'Reilly and other publishers, and he recently joined O'Reilly as an associate editor, specializing in Oracle books. Jonathan was formerly a manager in KPMG's Public Services Systems Integration practice, where he was also the lead database administrator for the utilities group working out of KPMG's Detroit office. He has more than a decade of experience with relational databases. Jonathan is a member of MENSA, and he holds a bachelor of arts degree in information and computer science from Andrews University in Berrien Springs, Michigan. He currently resides in Munising, Michigan, with his wife Donna and their two children: twelve- year-old Jenny, who often wishes her father wouldn't spend quite so much time writing, and five-year-old Jeff, who has never seen it any other way. 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 in systems science and automation. He is the coauthor of Oracle Parallel Processing (O'Reilly & Associates, 2000) and can be reached at sanjay_mishra@i2.com.

Reviews for Oracle SQL*Loader: The Definitive Guide: Loading Data into an Oracle Database

"'Wow the title hits it bulls-eye - The Definitive Guide. - A humongous effort went into the book and the examples. It's another one for the desk, always to hand. Bravo Well Done"" plomax@oriole.com"