CHAPTER 21Using SQL*Loader to Load Data
In the scripts provided for the practice tables, a large number of insert commands are executed. In place of those inserts, you could create a file containing the data to be loaded and then use Oracle’s SQL*Loader utility to load the data. This chapter provides you with an overview of the use of SQL*Loader and its major capabilities. Two additional data-movement utilities, Data Pump Export and Data Pump Import, are covered in Chapter 22. SQL*Loader, Data Pump Export, and Data Pump Import are described in great detail in the Oracle Database Utilities provided with the standard Oracle documentation set.
SQL*Loader loads data from external files into tables in the Oracle database. SQL*Loader uses two primary ...
Get Oracle Database 10g The Complete Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
