SQL> SQL> CREATE DIRECTORY infile AS 'c:\oraclass'; Directory created. SQL> SQL> select * from all_directories; OWNER DIRECTORY_NAME ------------------------------ ------------------------------ DIRECTORY_PATH -------------------------------------------------------------------------------- SYS DATA_PUMP_DIR C:\oraclexe\app\oracle\admin\XE\dpdump\ SYS BFILE_DIR c:\proj SYS ORACLECLRDIR C:\oraclexe\app\oracle\product\10.2.0\server\bin\clr OWNER DIRECTORY_NAME ------------------------------ ------------------------------ DIRECTORY_PATH -------------------------------------------------------------------------------- SYS UDUMP_DIR c:/udump SYS CLASS c:\temp SYS MY_FILES c:\temp\ OWNER DIRECTORY_NAME ------------------------------ ------------------------------ DIRECTORY_PATH -------------------------------------------------------------------------------- SYS INFILE c:\oraclass 7 rows selected. SQL> SQL> DROP DIRECTORY infile; Directory dropped. SQL>