External Tables - Oracle
An external table is a table that is NOT stored within the Oracle database. Data is loaded from a file via an access driver (normally ORACLE_LOADER) when the table is accessed. One can think of an external table as a view that allows running SQL queries against files on a filesystem without the need to first loaded the data into the database.
Prepare test data. For our example we need to create a file called report.csv with the following data:
Create a database directory to match your already existing OS directory and grant your Oracle user READ and WRITE access to it:
Create the external table definition:
Select from the external table will invoke a load of the data on filesystem: