Part III External Tables

The following topics provide information necessary to successfully using external tables:

External Tables Concepts

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.

External Tables Examples

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 the ORACLE_HDFS or ORACLE_HIVE access drivers are specified in a SQL CREATE TABLE ORGANIZATION EXTERNAL statement, in the opaque_format_spec clause of ACCESS PARAMETERS.
• External Tables Examples