Oracle创建、查看、修改、赋权、删除directory目录
创建directory一般是为了用数据泵导入/导出数据用,
创建directory语法:
CREATE [OR REPLACE] DIRECTORY directory AS 'pathname';
例如:
create or replace directory dumpdir as '/home/oracle/datatmp'
这样把目录/home/oracle/datatmp设置成dumpdir代表的directory
查看directory路径:
select * from dba_directories;
修改directory
create or replace directory dumpdir as '/home/dumpfiles';
即更改dumpdir目录的路径为/home/dumpfiles
directory赋权
grant read,write on directory dumpdir to username;
directory删除
drop directory DIRENAME;
Tag标签:「directory 目录 赋权」更新时间:「2021-11-03 09:26:44」阅读次数:「1834」