Part III External Tables
To use external tables successfully, find out about external table concepts, and see examples of what options are available to you to use external tables with Oracle Database.
- External Tables Concepts
The external tables feature is a complement to existing SQL*Loader functionality. It enables you to access data in external sources as if it were in a table in the database. - The ORACLE_LOADER Access Driver
Learn how to control the way external tables are accessed by using the ORACLE_LOADER access driver parameters to modify the default behavior of the access driver. - The ORACLE_DATAPUMP Access Driver
TheORACLE_DATAPUMP
access driver provides a set of access parameters that are unique to external tables of the typeORACLE_DATAPUMP
. - ORACLE_BIGDATA Access Driver
With theORACLE_BIGDATA
access driver, you can access data stored in object stores as if that data was stored in tables in an Oracle Database. - External Tables Examples
Learn from these examples how to use theORACLE_LOADER
,ORACLE_DATAPUMP
,ORACLE_HDFS
, andORACLE_HIVE
access drivers to query data in Oracle Database and Big Data.