「Oracle 12c」 ディレクトリオブジェクトの一覧を確認する
システム環境
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