DBA_DIRECTORIES
DBA_DIRECTORIESの仕様
 名前                                    NULL?    型
 ----------------------------------------- -------- ----------------------------
 OWNER                                     NOT NULL VARCHAR2(30)
 DIRECTORY_NAME                            NOT NULL VARCHAR2(30)
 DIRECTORY_PATH                                     VARCHAR2(4000)
使用例
PROD(SYS)>col owner format a10
PROD(SYS)>col directory_name format a30
PROD(SYS)>col directory_path format a60
PROD(SYS)>select * from dba_directories;

OWNER      DIRECTORY_NAME                 DIRECTORY_PATH
---------- ------------------------------ ------------------------------------------------------------
SYS        DATAPUMP_DIR                   /U01/APP/ORACLE/DATAPUMP_DIR
SYS        DATA_PUMP_DIR                  /u01/app/oracle/product/10.2.0/db_1/rdbms/log/

PROD(SYS)>
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License