Oracle PL/SQL/Table/External Table

Create external table with data path specified

   <source lang="sql">

SQL> -- external table SQL> SQL> create directory ext_data_files

 2        as "D:\ORACLE\ORA90\EXTERNAL";

Directory created. SQL>

      </source>