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

posted @ 2015-07-29 21:07  LJ9197  阅读(256)  评论(0编辑  收藏  举报