Oracle创建directory 1、新建directory的语法 create or replace directory dmp as 'E:\lydmp'; 这样把目录E:\lydmp设置成dmp代表的directory 2、查询有哪些directory select * from dba_directories; 3、赋权 grant read,write on directory dmp to user; 4、删除 drop directory dump_dir