ENGLISH

Oracle SQL*Loader: The Definitive Guide

By Sanjay Mishra , Jonathan Gennick

Book information

Publisher
O'Reilly Media
Year
2001
ISBN
9781565929487, 1-56592-948-9
Open Library ID
OL3584322M
Language
english
Format
DJVU
Filesize
2 MB (2142468 bytes)
Edition
1
Pages
270\270
Topic
Computers Databases
Time added
2014-10-05 02:30:00

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

Similar books