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:  Facebook: dbagenesis
Instagram:  Instagram: dbagenesis
Twitter:  Twitter: DbaGenesis

• #science_technology
• #oracle_dba
• #oracle_external_table
• #excel_external_table
• #sql_loader_in_oracle
• #sql_loader_vs_external_table
• #loading_data_from_external_tables