Oracle SQL*Loader: The Definitive Guide
| |||||||||||||||||||||||||||||
|
| |||||||||||||||||||||||||||||
| Sort customer reviews by: | |||||||||||||||||||||||||||||
|
Show All Reviews on Page
Hide All Reviews on Page
| |||||||||||||||||||||||||||||
| Oracle SQL*Loader: The Definitive Guide | |||||||||||||||||||||||||||||
|
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 Oracle8i. 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: The Definitive Guide has everything you need to know to put SQL*Loader to its best use: an introduction to SQL*Loader, a reference to all of its syntax options, and most importantly, step-by-step instructions for all the SQL*Loader 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 SQL*Loader performance by adjusting the transaction size and using the new direct path option. It also covers the newest SQL*Loader features--the loading of large object (LOB) columns and the new object types (nested tables, varying arrays, and object tables). Oracle SQL*Loader: The Definitive Guide is an indispensable resource for anyone who is new to SQL*Loader; 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.
|
|||||||||||||||||||||||||||||
| Reader Reviews 1 - 14 of 14 | |||||||||||||||||||||||||||||
| Review Date |
Review Rating(5 High) |
Review Helpful to: |
Customer Review | Reviewer Info |
Permanent Link |
||||||||||||||||||||||||
| Reader Reviews Below Sorted by Newest First | |||||||||||||||||||||||||||||
| 10-09-08 | 5 | (NA) |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
The authors have done a superb job of covering all corner cases that one might encounter while loading data in the database. The text is sprinkled with practical advise, do's & dont's
I am not sure if sqlloader development has kept up with the database development (i.e. if there exists a 10g version of the sqlloader to go with the 10g Oracle database). If so, then I wish they will come up with a second edition of the book. (Review Data Last Updated: 2008-11-30 06:55:54 EST)
|
|||||||||||||||||||||||||||||
| 10-26-07 | 2 | (NA) |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
This book contains a somewhat disjointed overview of SQL*Loader. It starts to explain something and then shows one little example of a character column, for instance. But then there is nothing at all about what to do if the column is a number or date. It explains a lot but it shows little. A very frustrating book.
Oracle's SQL*Loader is fragile, counter-intuitive, dated, and hard to work with. If there were ANY other books available, I would try one of those instead. (Review Data Last Updated: 2008-10-09 06:39:09 EST)
|
|||||||||||||||||||||||||||||
| 10-16-05 | 5 | 0\1 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
This little book is a lifesaver. I have benefitted a lot from the examples provided in this book. SQL Loader can be hard but very easy if you have a guide like this book.
(Review Data Last Updated: 2007-10-26 23:04:53 EST)
|
|||||||||||||||||||||||||||||
| 10-15-05 | 5 | 0\1 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
This little book is a lifesaver. I have benefitted a lot from the examples provided in this book. SQL Loader can be hard but very easy if you have a guide like this book.
(Review Data Last Updated: 2007-04-11 10:37:49 EST)
|
|||||||||||||||||||||||||||||
| 12-08-04 | 5 | 2\2 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
I have been dealing with databases for over three years now.
Right now I am doing Siebel Consulting in which Enterprise Integration Module(EIM) is responsible for data transfer from any source to Sieble database. I came across a requirement where I had to use Oracle SQL Loader, so I went looking for a good book. This 250 page book tells you everything you need to know about SQL Loader in less time than any other. Lots of code and real time examples. Worth having as ref book for all DBAs or even developers. Five Stars for sure. (Review Data Last Updated: 2007-07-08 20:07:37 EST)
|
|||||||||||||||||||||||||||||
| 02-19-04 | 5 | 4\4 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
I searched through several manuals and guides on Oracle only to discover that very few cover the SQL Loader tool in great detail. This book does so, and in a way that's fairly easy to read. It is a huge benefit over the sparse 2-3 pages of documentation you'll typically find elsewhere.
(Review Data Last Updated: 2007-07-08 20:07:37 EST)
|
|||||||||||||||||||||||||||||
| 07-06-03 | 4 | 3\3 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
This is the place to start if you want to know about SQL*Loader. The authors do a great job on covering how to use SQL*Loader and all the little nuances that it has. They also sprinkles in some good advise on how to handle situation that will probably come up when you use SQL*Loader. The back cover of the book indicates that it is updated for Oracle 9i. I have a little reservation about that because the book was written with an early release of Oracle 9i (it states so on page xii and xii).
Bottom line: start with this book for the easy read and clear explanations. Then go to the Oracle 9i doc for the updates like the Control File being expanded to include new parameters. (Review Data Last Updated: 2007-07-08 20:07:37 EST)
|
|||||||||||||||||||||||||||||
| 03-16-03 | 4 | 3\4 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
This is a good book for anyone needing or wanting to learn more about SQL Loader. The book begins by laying the foundation for SQL Loader and discussing "The Mysterious Control File". After that it discusses the two types of files that can be loaded - fixed lenght and delimited files. With the basics covered, the authors turn to error recovery and advanced features such as selective loading and direct path loads. After reading this book, you should have a good idea of what SQL Loader can and cannot do along with some of the finer points of when to and not to use SQL Loader. A knowledge of Oracle SQL is really all that is required to understand the material presented. This book is a must have for any shop using Oracle for their database.
(Review Data Last Updated: 2007-07-08 20:07:37 EST)
|
|||||||||||||||||||||||||||||
| 03-15-03 | 4 | 3\4 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
This is a good book for anyone needing or wanting to learn more about SQL Loader. The book begins by laying the foundation for SQL Loader and discussing "The Mysterious Control File". After that it discusses the two types of files that can be loaded - fixed lenght and delimited files. With the basics covered, the authors turn to error recovery and advanced features such as selective loading and direct path loads. After reading this book, you should have a good idea of what SQL Loader can and cannot do along with some of the finer points of when to and not to use SQL Loader. A knowledge of Oracle SQL is really all that is required to understand the material presented. This book is a must have for any shop using Oracle for their database.
(Review Data Last Updated: 2006-07-05 14:58:28 EST)
|
|||||||||||||||||||||||||||||
| 01-06-03 | 4 | 2\3 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
This is a great book for the occaisional SQLLoad user--it'll tell you everything you need to know to use the tool, but after taking some oracle certification courses, I discovered more about the SQLLoader utility that's not covered in this book. I'm sure Oracle publishes a better book, but this one should suit you fine.
(Review Data Last Updated: 2007-07-08 20:07:37 EST)
|
|||||||||||||||||||||||||||||
| 11-18-02 | 4 | 1\1 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
This is not light reading, but it's a great reference and much better than the Oracle manuals on SQL Loader.
(Review Data Last Updated: 2006-07-05 14:58:28 EST)
|
|||||||||||||||||||||||||||||
| 09-02-02 | 5 | 2\2 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
Useful for both new and experienced Oracle DBAs and developers.
Initially, some co-workers scoffed, saying that the topic of SQL Loader does not need an entire book on the subject. However, after they looked at my copy, they changed their minds, and wanted to borrow it. (Review Data Last Updated: 2006-07-05 14:58:28 EST)
|
|||||||||||||||||||||||||||||
| 03-01-02 | 5 | 4\5 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
Very good book on SQL loader. Eveything is in one place and easy to find. Answered all my questions and I got a few ideas about other ways to use SQL loader.
(Review Data Last Updated: 2006-07-05 14:58:28 EST)
|
|||||||||||||||||||||||||||||
| 06-30-01 | 5 | 22\22 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
Although Oracle does a reasonable job of clearly explaining SQL*Loader, this guide takes it a giant leap forward. First it collects everything you ever needed or wanted to know about SQL*Loader into a 251 page reference. It's written in a friendlier fashion than Oracle's documentation, and with more examples that are better written. On the whole, this promotes a better understanding of SQL*Loader, its strengths and limitations, and will allow DBAs to master every facet and nuance of this powerful tool. Considering the damage that can be inflicted on a production database if SQL*Loader is improperly used, all DBAs who use this tool to load data (and who doesn't?) should read this book and have a copy on their desk.
Another use for this book is as a training aid for new DBAs and as the basis for database administration policies and procedures that spell out when and how to load data into a production system. It also contains a wealth of information that can be incorporated into change control implementation and rollback plans when massive updates need to be performed. I like the thorough treatment, the fact that it's up-to-date, and the advice and tips that are imparted throughout this book. It's definitely a good addition to your professional library. (Review Data Last Updated: 2006-07-05 14:58:28 EST)
|
|||||||||||||||||||||||||||||
| Reader Reviews 1 - 14 of 14 | |||||||||||||||||||||||||||||
| All Books | Arts | Biography | Click Here For An A-Z Index Of All 213 Best-Seller Subjects | Business | Children's | Comics | ||||||
| Computers | Cooking | Engineering | Entertainment | Health | History | Home | Horror | Humor | Law | Fiction | Medicine | Mystery |
| Nonfiction | Outdoors | Parenting | Professional | Reference | Religion | Romance | Science | Sci-Fi | Sports | Teens | Travel | |
