1、新建directory的语法
create or replace directory dump_dir as '/home/oracle/database'
2、赋权
grant read,write on directory dump_dir to myuser
myuser为哪些用户分配此dir的权限;
3、查询有哪些directory
select * from dba_directories
4、删除
drop directory dump_dir
1、新建directory的语法
create or replace directory dump_dir as '/home/oracle/database'
2、赋权
grant read,write on directory dump_dir to myuser
myuser为哪些用户分配此dir的权限;
3、查询有哪些directory
select * from dba_directories
4、删除
drop directory dump_dir