Oracle PL/SQL Tutorial/System Tables Data Dictionary/all directories

Create a directory alias pointing to your class subdirectory

   <source lang="sql">

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