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

Create a directory alias pointing to your class subdirectory

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>