Oracle Database Directory
Oracle database directory is used for file I/O between Oracle database and the OS. The directory is also used for uploading data files using Oracle SQLLDR  (2) , BFILE management, data warehouse ETL processes, ETL tools and for ETL using external tables .

Script to create Oracle database directory

CREATE OR REPLACE DIRECTORY file_io AS '/usr/log/file_io';

GRANT READ ON DIRECTORY file_io TO dwuser WITH GRANT OPTION;
Oracle registered trademark of Oracle Corporation.

Last Revised On: October 13, 2013