ablog

不器用で落着きのない技術者のメモ

Data Pump で使えるディレクトリを確認する SQL

Oracle 
set linesize 200
col owner for a10
col privilege for a10
col directory_path for a50
select d.owner, d.directory_name, p.grantee, p.privilege, d.directory_path
		from dba_directories d, dba_tab_privs p
		where d.owner = p.owner
			and d.directory_name = p.table_name
		order by d.owner, d.directory_name;
  • 実行結果
OWNER      DIRECTORY_NAME                 GRANTEE                        PRIVILEGE  DIRECTORY_PATH
---------- ------------------------------ ------------------------------ ---------- --------------------------------------------------
SYS        DATA_PUMP_DIR                  EXP_FULL_DATABASE              WRITE      /u01/app/oracle/admin/orcl/dpdump/
SYS        DATA_PUMP_DIR                  IMP_FULL_DATABASE              WRITE      /u01/app/oracle/admin/orcl/dpdump/
SYS        DATA_PUMP_DIR                  IMP_FULL_DATABASE              READ       /u01/app/oracle/admin/orcl/dpdump/
SYS        DATA_PUMP_DIR                  EXP_FULL_DATABASE              READ       /u01/app/oracle/admin/orcl/dpdump/
SYS        ORACLE_OCM_CONFIG_DIR          ORACLE_OCM                     WRITE      /u01/app/oracle/product/10.2.0/db_1/ccr/state
SYS        ORACLE_OCM_CONFIG_DIR          ORACLE_OCM                     READ       /u01/app/oracle/product/10.2.0/db_1/ccr/state

6 rows selected.

参考