Mega Code Archive

 

Categories / Oracle PLSQL / 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>