oracle目录操作

1.创建目录

 create directory dir_name as 'dir_path'  (dir_path必须事先手动创建)

2.授权

grant read,write on directory dir_name to user;

3.查看所有目录

select * from dba_directories;

4.应用事例

expdp yx/abc123@orcl directory=dir_name dumpfile=eas32.dmp  network_link=DBLinkeas32

原文地址:https://www.cnblogs.com/cyhj/p/4687340.html