Part III External Tables
The topics discussed in this part include information necessary to successfully use external tables.
- 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
TheORACLE_LOADER
access driver provides a set of access parameters unique to external tables of the typeORACLE_LOADER
. - 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_HDFS and ORACLE_HIVE Access Drivers
The properties used to create an external table that uses theORACLE_HDFS
orORACLE_HIVE
access drivers are specified in a SQLCREATE TABLE ORGANIZATION EXTERNAL
statement, in theopaque_format_spec
clause ofACCESS PARAMETERS
. - External Tables Examples
Examples using external tables.