Oracle External Table
Whit this feature you can access data in external sources as if it were a table in the database. Prior to release 10g external tables were read-only (9i); from release 10g external tables can also be written too. To use the external tables feature you must have knowledge of the file format and record format of the datafiles on your platform if the ORACLE_LOADER access driver is used and the “source” is in text format. When you create an external table you must specify : o TYPE: ORACLE_LOADER (default). You can run only for loading data and the data must...