CHAPTER 15Data Loading and Unloading

In this chapter, we will discuss data loading and unloading—in other words, how to get data into and out of an Oracle database. The main focus of the chapter is on the following bulk data loading tools:

  • SQL*Loader (pronounced "sequel loader"): This is still a predominant method for loading data.
  • External tables: This is a new feature with Oracle9i and above that permits access to operating system files as if they were database tables and, in Oracle 10g and above, even allows for the creation of operating system files as extracts of tables.

In the area of data unloading, we'll look at two techniques:

  • Flat file unload: The flat file unloads will be custom developed implementations, but will provide you with ...

Get Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.