|
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>
|