Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

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>