My Oracle Support Banner

External Tables Overview and Usage (Doc ID 150740.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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




Purpose

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

Scope

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.

Details

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
Purpose
Scope
Details
 What are External Tables?
References

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