分类: Oracle

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;

相关文章

发表新评论