Part III External Tables
The following topics provide information necessary to successfully using external tables:
Describes basic concepts about external tables.
The ORACLE_LOADER Access Driver
Describes the ORACLE_LOADER
access driver.
The ORACLE_DATAPUMP Access Driver
Describes the ORACLE_DATAPUMP
access driver, including its parameters, and information about loading and unloading supported data types.
ORACLE_HDFS and ORACLE_HIVE Access Drivers
Describes the ORACLE_HDFS
and ORACLE_HIVE
access drivers.
Provides examples of using external tables, including partitioned external tables.
- External Tables Concepts
- The ORACLE_LOADER Access Driver
- The ORACLE_DATAPUMP Access Driver
- 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