CHAPTER23Using 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 SQL*Loader and its major capabilities. Two additional data-movement utilities, Data Pump Export and Data Pump Import, are covered in Chapter 24. SQL*Loader, Data Pump Export, and Data Pump Import are described in great detail in the Oracle Database Utilities documentation provided with the standard Oracle documentation set. ...
Get Oracle Database 12c 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.
