© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2024
M. Malcher, D. KuhnPro Oracle Database 23c Administrationhttps://doi.org/10.1007/978-1-4842-9899-2_15

15. External Tables

Michelle Malcher1   and Darl Kuhn2
(1)
Huntley, IL, USA
(2)
Morrison, CO, USA
 

External tables are an easy way to use files to load data, run queries against to provide transformations, load only needed data, or use the files as reference data without even loading it to the database tables.

The Oracle external table feature enables you to perform a few operations:

  • Transparently select information from OS files that have been delimited or from fixed fields into the database.

  • Create platform-independent dump files that can be used to transfer data. ...

Get Pro Oracle Database 23c Administration: Manage and Safeguard Your Organization’s Data 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