转自:https://zhidao.baidu.com/question/921271686131558779.html
使用
select * from dba_directories;
可以查到,例如:
OWNER DIRECTORY_NAME DIRECTORY_PATH
1 SYS EXPDIR D:\app\Administrator\admin\orcl\dpdump
2 SYS UDIR D:\app\Administrator\admin\orcl\dpdump
3 SYS XMLDIR c:\ade\aime_dadvfm0254\oracle\rdbms\xml
4 SYS DPDATA D:\app\Administrator\admin\orcl\dpdump
5 SYS DATA_PUMP_DIR C:\app\Administrator\admin\orcl\dpdump\
6 SYS ORACLE_OCM_CONFIG_DIR C:\app\Administrator\product\11.2.0\dbhome_1\ccr\state