Oracle PL/SQL/Table/External Table
Create external table with data path specified
SQL> -- external table
SQL>
SQL> create directory ext_data_files
2 as "D:\ORACLE\ORA90\EXTERNAL";
Directory created.
SQL>
SQL> -- external table
SQL>
SQL> create directory ext_data_files
2 as "D:\ORACLE\ORA90\EXTERNAL";
Directory created.
SQL>