메뉴얼을 근거로 보면, 안되네요.
Oracle® Database PL/SQL Packages and Types Reference 11g Release 2
(11.2)
Given the following:
SQL> CREATE DIRECTORY log_dir AS '/appl/gl/log'; SQL> GRANT READ ON DIRECTORY log_dir TO DBA; SQL> GRANT WRITE ON DIRECTORY log_dir TO DBA; SQL> CREATE DIRECTORY USER_DIR AS '/appl/gl/user''; SQL> GRANT READ ON DIRECTORY USER_DIR TO PUBLIC; SQL> GRANT WRITE ON DIRECTORY USER_DIR TO PUBLIC;
The following file locations and filenames are valid and accessible as follows:
File Location | Filename | READ and WRITE |
---|---|---|
/appl/gl/log |
L12345.log |
Users with DBA privilege |
/appl/gl/user |
u12345.tmp |
All users |
The following file locations and filenames are invalid:
File Location | Filename | Invalid Because |
---|---|---|
/appl/gl/log/backup |
L12345.log |
# subdirectories are not accessible |
/APPL/gl/log |
L12345.log |
# directory strings must follow case sensitivity rules as required by the O/S |
/appl/gl/log |
backup/L1234.log |
# filenames may not include portions of directory paths |
/user/tmp |
L12345.log |
# no corresponding CREATE
DIRECTORY command has been issued |