Oracle¶ÔĿ¼Îļþ(directory)µÄ¶Áд²Ù×÷

Create directoryÈÃÎÒÃÇ¿ÉÒÔÔÚOracleÊý¾Ý¿âÖÐÁé»îµÄ¶ÔÎļþ½øÐжÁд²Ù×÷£¬¼«´óµÄÌá¸ßÁËOracleµÄÒ×ÓÃÐԺͿÉÀ©Õ¹ÐÔ¡£
ÆäÓ﷨Ϊ:
create or replace directory exp_dir as '/tmp';
Ŀ¼´´½¨ÒԺ󣬾ͿÉÒ԰ѶÁдȨÏÞÊÚÓèÌض¨Óû§£¬ÀýÈç:
grant read, write on directory exp_dir to eygle;
´ËʱÓû§eygle¾ÍÓµÓÐÁ˶ԸÃĿ¼µÄ¶ÁдȨÏÞ¡£
ÀýÈç:
µ±ÓÃSCOTT½øÐÐĿ¼´´½¨µÄʱºò,Ê×ÏÈÓ¦¸Ã¸³¸øSCOTT´´½¨Ä¿Â¼µÄȨÏÞ,Èç¹ûûÓÐÔò»á±¨Ò»Ï´íÎó
SQL> create or replace directory MY_DIR   as 'd:\test';
          create or replace directory MY_DIR   as 'd:\test'
          ORA-01031: ȨÏÞ²»×ã
SQL> GRANT CREATE ANY DIRECTORY TO scott;--ÊÚȨ¸øSCOTTÓû§´´½¨Ä¿Â¼È¨ÏÞ
           Grant succeeded
SQL>create or replace directory MY_DIR   as 'd:\test';--´´½¨ÁËÒ»¸öĿ¼ÃûΪ'MY_DIR'µÄĿ¼,ËûµÄ·¾¶ÊÇ'd:\test'
           Directory created.
SQL>select * from all_directories;--²é¿´´´½¨µÄĿ¼
          OWNER    DIRECTORY_NAME      DIRECTORY_PATH
              SYS                MY_DIR                        d:\test
SQL> drop directory my_dir;--ɾ³ýĿ¼
           Directory dropped
дÈëÎļþ:
SQL> DECLARE
  2  filehandle  utl_file.file_type;
  3  begin
  4  filehandle := utl_file.fopen('MY_DIR','test.txt','w');
  5  utl_file.put_line(filehandle,'test 1 write one.');
  6  utl_file.put_line(filehandle,'ÄãºÃ!');
  7  utl_file.fclose(fil