My Oracle Support Banner

External Tables Overview and Usage (Doc ID 150740.1)

Last updated on FEBRUARY 02, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


This note explains the purpose and usage of external tables.
External tables is introduced in version 9i of Oracle.


For DBAs who need to store data outside the database and manipulate them inside the database without requiring to load the data in the database.

This feature becomes interesting in a data warehouse environment during the ETL process (Extraction Transformation Loading), as a complement to SQL*Loader: it prevents temporary tables to be created during the Extraction and Transformation phases, thus reducing space allocated and risk of abnormal termination during the whole process. It can be used in place of SQL*Loader when the external data volume is large and used only once.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 What are External Tables?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.