Ddmit
创建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
