© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
D. Kuhn, T. KyteExpert Oracle Database Architecturehttps://doi.org/10.1007/978-1-4842-7499-6_15

15. Data Loading and Unloading

Darl Kuhn1   and Thomas Kyte2
(1)
Morrison, CO, USA
(2)
Denver, CO, USA
 
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:

  • External tables: This is a feature that permits access to operating system files as if they were database tables and even allows for the creation of operating system files as extracts of tables.

  • SQL*Loader (pronounced “sequel loader” and hereafter referred to as SQLLDR) ...

Get Expert Oracle Database Architecture: Techniques and Solutions for High Performance and Productivity 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.

Start your free trial