Understanding Oracle External Tables

28 Jan 2019
15:00 - 15:45

Understanding Oracle External Tables

Oracle External Tables have become richer in the last 5 years with the addition of the ORACLE_HIVE and ORACLE_BIGDATA, Big Data SQL and Partitioned External Tables. We’ll discuss: the different driver types, security, datatypes , I18N, and PQ, and for the DBA: dictionary, tracing, and wait events.

It has long puzzled me that I’ve never seen Oracle External Tables as a talk at any OUG but they are an essential part of any DBA’s arsenal.
Oracle External Tables have become much richer and more complex in the last five years with the addition of
– ORACLE_HIVE and ORACLE_BIGDATA drivers, and Big Data SQL
– Partitioned and hybrid external tables
– In -Memory External Tables
This talk aims to review the basics and also review the rich syntax options up to and including new features in 18.1c.
In particular, we will discuss: the different driver types, security, datatype conversions, character set mismatch, performance, parallel query, and how to integrate corporate data in Oracle and data stored externally seamlessly.

This talk will NOT cover the utilities e.g. Datapump.