Oracle创建directory

1、新建directory的语法

CREATE [OR REPLACE] DIRECTORY directory AS 'pathname';   例如： create or replace directory dump_dir as 'D:\dump\dir' 这样把目录d:\dump\dir设置成dump_dir代表的directory   2、查询有哪些directory select * from dba_directories   3、赋权 grant read,write on directory dump_dir to user01   4、删除 drop directory dump_dir