「Oracle 12c」 ディレクトリオブジェクトの一覧を確認する
システム環境
Windows Server 2012 R2
Oracle 12.2.0.1.0
Windows Server 2012 R2
Oracle 12.2.0.1.0
Windows Server 2012 R2 Oracle 12.2.0.1.0
SQL構文
SELECT * FROM DBA_DIRECTORIES;
OWNER: 所有者
DIRECTORY_NAME: ディレクトリ名
DIRECTORY_PATH: ディレクトリのパス
操作例
SQL> select * from dba_directories;
OWNER DIRECTORY_NAME DIRECTORY_PATH
------------------------------ ---------------- ---------------------------------
SYS XMLDIR C:\oracle\product\12.2.0\dbhome_1/rdbms/xml
SYS XSDDIR C:\oracle\product\12.2.0\dbhome_1/rdbms/xml/schema
SYS ORA_DBMS_FCP_LOGDIR C:\oracle\product\12.2.0\dbhome_1/cfgtoollogs
SYS ORA_DBMS_FCP_ADMINDIR C:\oracle\product\12.2.0\dbhome_1/rdbms/admin
SYS OPATCH_INST_DIR C:\oracle\product\12.2.0\dbhome_1\OPatch
SYS ORACLE_OCM_CONFIG_DIR C:\oracle\product\12.2.0\dbhome_1\ccr\state
SYS DATA_PUMP_DIR C:\oracle\admin\test\dpdump\
SYS ORACLE_OCM_CONFIG_ C:\oracle\product\12.2.0\dbhome_1\ccr\state
SYS OPATCH_SCRIPT_DIR C:\oracle\product\12.2.0\dbhome_1\QOpatch
SYS OPATCH_LOG_DIR C:\oracle\product\12.2.0\dbhome_1\QOpatch
SYS ORACLE_BASE C:\oracle
SYS ORACLE_HOME C:\oracle\product\12.2.0\dbhome_1
SQL> select * from dba_directories;
OWNER DIRECTORY_NAME DIRECTORY_PATH
------------------------------ ---------------- ---------------------------------
SYS XMLDIR C:\oracle\product\12.2.0\dbhome_1/rdbms/xml
SYS XSDDIR C:\oracle\product\12.2.0\dbhome_1/rdbms/xml/schema
SYS ORA_DBMS_FCP_LOGDIR C:\oracle\product\12.2.0\dbhome_1/cfgtoollogs
SYS ORA_DBMS_FCP_ADMINDIR C:\oracle\product\12.2.0\dbhome_1/rdbms/admin
SYS OPATCH_INST_DIR C:\oracle\product\12.2.0\dbhome_1\OPatch
SYS ORACLE_OCM_CONFIG_DIR C:\oracle\product\12.2.0\dbhome_1\ccr\state
SYS DATA_PUMP_DIR C:\oracle\admin\test\dpdump\
SYS ORACLE_OCM_CONFIG_ C:\oracle\product\12.2.0\dbhome_1\ccr\state
SYS OPATCH_SCRIPT_DIR C:\oracle\product\12.2.0\dbhome_1\QOpatch
SYS OPATCH_LOG_DIR C:\oracle\product\12.2.0\dbhome_1\QOpatch
SYS ORACLE_BASE C:\oracle
SYS ORACLE_HOME C:\oracle\product\12.2.0\dbhome_1
SQL> select * from dba_directories; OWNER DIRECTORY_NAME DIRECTORY_PATH ------------------------------ ---------------- --------------------------------- SYS XMLDIR C:\oracle\product\12.2.0\dbhome_1/rdbms/xml SYS XSDDIR C:\oracle\product\12.2.0\dbhome_1/rdbms/xml/schema SYS ORA_DBMS_FCP_LOGDIR C:\oracle\product\12.2.0\dbhome_1/cfgtoollogs SYS ORA_DBMS_FCP_ADMINDIR C:\oracle\product\12.2.0\dbhome_1/rdbms/admin SYS OPATCH_INST_DIR C:\oracle\product\12.2.0\dbhome_1\OPatch SYS ORACLE_OCM_CONFIG_DIR C:\oracle\product\12.2.0\dbhome_1\ccr\state SYS DATA_PUMP_DIR C:\oracle\admin\test\dpdump\ SYS ORACLE_OCM_CONFIG_ C:\oracle\product\12.2.0\dbhome_1\ccr\state SYS OPATCH_SCRIPT_DIR C:\oracle\product\12.2.0\dbhome_1\QOpatch SYS OPATCH_LOG_DIR C:\oracle\product\12.2.0\dbhome_1\QOpatch SYS ORACLE_BASE C:\oracle SYS ORACLE_HOME C:\oracle\product\12.2.0\dbhome_1