Create a directory alias pointing to your class subdirectory : all_directories « System Tables Data Dictionary « Oracle PL/SQL Tutorial






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>








30.6.all_directories
30.6.1.Create a directory alias pointing to your class subdirectory