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>