Oracle External Tables | Querying Data From External Files
External tables allow #Oracle to query #data that is stored outside the database in flat files. The ORACLE_LOADER driver can be used to access any data stored in any format that can be loaded by SQL*Loader. No DML can be performed on external tables but they can be used for #query, join and sort operations. #Views and synonyms can be created against external tables. They are useful in the #ETL process of data warehouses since the data doesn't need to be staged and can be queried in parallel. They should not be used for frequently queried #tables.
00:00 SQL * Loader Utility
01:23 Oracle External Tables
05:20 Create flat files
06:03 Create directories object
06:37 Create external table
12:20 Query external table
13:23 Create view on external table
14:25 Load operation log
Website: https://www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis