创建目录:

create or replace directory dumpdir as '/home/dumpfiles';

查看目录：

select * from dba_directories;

删除目录：

drop directory exp_dir;