Oracle SQL*Loader: The Definitive Guide

Oracle SQL*Loader: The Definitive Guide (Paperback)
by Jonathan Gennick(Author), Sanjay Mishra (Author)

# Paperback: 272 pages
# Publisher: O’Reilly Media, Inc.; 1st edition (April 19, 2001)
# Language: English
# ISBN-10: 1565929489
# ISBN-13: 978-1565929487

Product Description

SQL*Loader is a utility used to load data from flat files into an Oracle database. Despite its wide availability and use, few Oracle users know how to get the most out of it. This book has everything you need to know about SQL*Loader: a reference to all of its syntax options and step-by-step instructions for all of 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, load from different types of files containing different types of data, validate data, load data selectively, transform data as it is loaded, and recover after failure. The book shows 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).

About the Author
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 SQL*Loader (O’Reilly & Associates, 2001); Oracle SQL*Plus 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.

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 choice 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.

Oracle SQL*Loader: The Definitive Guide (Paperback)
by Jonathan Gennick, Sanjay Mishra
ISBN: 1565929489
Publisher: O’Reilly Media

Price: USD 29.19
25 used & new available from USD 14.52

| 4.5 | 11

Popularity: 1% [?]

Download Links:

(2 votes, average: 4.50 out of 5)

 Loading ...

Related eBooks - Up | Down

A Practical Guide to Data Structures and...

A Practical Guide to Data Structures and Algorithms using Java Author: Sally A. Goldman, Kenneth J. Goldman Publisher: Chapman and Hall/CRC Publication Date: 2007-08-23 ISBN-10: 158488455X ISBN-13: 9781584884552 Hardcover: 1056 Pages Although traditional texts present isolated algorithms and data structures, they do not provide ...
Download

(No Ratings Yet)

 Loading ...

Tags:algorithms, Data, guide, Java, Practical, Structures; 8 downloads ; Comments: 2 Responses

The Nexus One Pocket Guide...

The Nexus One Pocket Guide Author: Jason D. O'Grady Publisher: Peachpit Press; 1 edition Publication Date: 2010-05-08 ISBN-10: 0321719700 ISBN-13: 9780321719706 Paperback: 240 Pages In this handy new Pocket Guide, mobile device expert Jason O'Grady reveals the secrets to using Google's Nexus One smartphone. ...
Download

(No Ratings Yet)

 Loading ...

Tags:guide, Nexus, Pocket; 4 downloads ; Comments: One Response

Measuring Public Relationships: The Data...

Measuring Public Relationships: The Data-Driven Communicator's Guide to Success Author: Katie Delahaye Paine Publisher: KDPaine & Partners, LLC Publication Date: 2007-12-12 ISBN-10: 0978989902 ISBN-13: 9780978989903 Paperback: 204 Pages Katie Delahaye paine's "Measuring Public Relations" is the must-have practical guide to hands-on PR measurement. Emphasizing ...
Download

(No Ratings Yet)

 Loading ...

Tags:Communicator's, DataDriven, guide, Measuring, Public, Relationships, Success; 3 downloads ; Comments: 2 Responses

Head First WordPress: A Brain-Friendly G...

Head First WordPress: A Brain-Friendly Guide to Creating Your Own Custom WordPress Blog Author: Jeff Siarto Publisher: O'Reilly Media; 1 edition Publication Date: 2010-07-23 ISBN-10: 0596806280 ISBN-13: 9780596806286 Paperback: 368 Pages Whether you’re promoting your business or writing about your travel adventures, Head First WordPress ...
Download

(1 votes, average: 5.00 out of 5)

 Loading ...

Tags:blog, BrainFriendly, Creating, guide, Head, wordpress; 7 downloads ; Comments: One Response

Photoshop CS5 for Windows and Macintosh:...

Photoshop CS5 for Windows and Macintosh: Visual QuickStart Guide Author: Elaine Weinmann, Peter Lourekas Publisher: Peachpit Press; 1 edition Publication Date: 2010-06-19 ISBN-10: 0321701534 ISBN-13: 9780321701534 Paperback: 456 Pages This best-selling guide from authors Elaine Weinmann and Peter Lourekas has been the go-to tutorial and ...
Download

(No Ratings Yet)

 Loading ...

Tags:guide, Macintosh, Photoshop, QuickStart, Visual, Windows; 22 downloads ; Comments: One Response

WordPress Theme Design: A complete guide...

WordPress Theme Design: A complete guide to creating professional WordPress themes Author: Tessa Blakeley Silver Publisher: Packt Publishing Publication Date: 2008-05-30 ISBN-10: 1847193099 ISBN-13: 9781847193094 Paperback: 224 Pages In Detail This title will take you through the ins and outs of creating sophisticated professional themes ...
Download

(1 votes, average: 5.00 out of 5)

 Loading ...

Tags:Complete, Creating, design, guide, Professional, Theme, Themes, wordpress; 11 downloads ; Comments: 5 Responses

The Photoshop CS5 Pocket Guide...

The Photoshop CS5 Pocket Guide Author: Brie Gyncild Publisher: Peachpit Press; 1 edition Publication Date: 2010-06-05 ISBN-10: 0321714326 ISBN-13: 9780321714329 Paperback: 240 Pages In this handy new Pocket Guide, Photoshop expert Brie Gyncild introduces readers to the powerful features in Photoshop CS5, including new features ...
Download

(No Ratings Yet)

 Loading ...

Tags:guide, Photoshop, Pocket; 24 downloads ; Comments: No Responses

My New iPad: A User’s Guide...

My New iPad: A User's Guide Author: Wallace Wang Publisher: No Starch Press; 1 edition Publication Date: 2010-06-17 ISBN-10: 1593272758 ISBN-13: 9781593272753 Paperback: 368 Pages The iPad is cute. It's lovable. It's fun to play with. And it's a bit mysterious. My New iPad is your ...
Download

(No Ratings Yet)

 Loading ...

Tags:guide, iPad, User's; 93 downloads ; Comments: One Response