|
Oracle SQL*Loader: The Definitive Guide
|
| List Price: | CDN$ 49.99 |
| Price: | CDN$ 32.48 & eligible for FREE Super Saver Shipping on orders over $39. Details |
Availability: Usually ships in 2 to 4 weeks
Ships from and sold by Amazon.ca
28 new or used available from CDN$ 1.83
Average customer review:
(8 )
Product 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.
Product Details
- Amazon Sales Rank: #955107 in Books
- Published on: 2001-04-26
- Original language: English
- Dimensions: .74" h x 7.04" w x 9.16" l, .96 pounds
- Binding: Paperback
- 272 pages
Editorial Reviews
From Amazon.co.uk
Oracle SQL*Loader: The Definitive Guide certainly lives up to the promise of its title. What this book doesn't tell you about Oracle's high performance data loading utility is unlikely to be found elsewhere--from the possible permutations of command line syntax and options to the fine detail of what each option means.
This book serves both as an introduction to SQL*Loader and as an in-depth reference to its use and behaviour. Having said that, it's perhaps debatable whether the relatively straightforward SQL*Loader merits the treatment it receives here and it's likely that the single chapter coverage in the Oracle Utilities manual, or any number of Oracle DBA reference books, will suffice for the average or occasional SQL*Loader user.
However, it will be a useful addition to the bookshelf of the regular SQL*Loader user, or for those where getting the most out of SQL*Loader is an issue. --Michael O'Connor
Review
'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
Book Info
A guide to loading data into an Oracle database, covering the SQL*Loader features for Oracle8 and Oracle8i and introduces features of the Oracle9i. Describes the utility, syntax options, and the procedures for performing tasks DBAs and developers perform with SQL*Loader. Also includes expanded support of direct path loads of objects and LOBs. Softcover.
