SQL>create directory dumpdir as '/home/dumpdata/';
复制代码
要更改dumpdir目录的路径,则为如下语句:
SQL>create or replace directory dumpdir as '/home/dumpfiles';
复制代码
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、赋权
<blockquote>grant read,write on directory dumpdir to glxt_user;