Oracle创建目录、授权、查看所有目录

创建oracle目录

请保证该oracle目录对应路径在磁盘真是存在，即事先在磁盘创建好oracle目录对应的文件夹。

SQL> create directory temp_dir as 'd:\dir_oracle' ;

目录已创建。

目录授权

SQL> grant read,write on directory temp_dir to jw_gfsp;

查看目录属性

SQL> desc dba_directories
Name           Type           Nullable Default Comments                                    
-------------- -------------- -------- ------- ------------------------------------------- 
OWNER          VARCHAR2(30)                    Owner of the directory (always SYS)         
DIRECTORY_NAME VARCHAR2(30)                    Name of the directory                       
DIRECTORY_PATH VARCHAR2(4000) Y                Operating system pathname for the directory 

查看创建的所有目录

SQL> select * from dba_directories;

OWNER                          DIRECTORY_NAME                 DIRECTORY_PATH
------------------------------ ------------------------------ --------------------------------------------------------------------------------
SYS                            ORACLE_OCM_CONFIG_DIR          D:\Programs\oracle\oracle11g\product\11.2.0\dbhome_2/ccr/state
SYS                            DATA_PUMP_DIR                  D:\Programs\oracle\oracle11g/admin/orcl/dpdump/
SYS                            TEMP_DIR                       d:\dir_oracle
SYS                            XMLDIR                         c:\ade\aime_dadvfh0169\oracle/rdbms/xml