重庆思庄Oracle、Redhat认证学习论坛

标题: 创建目录，为导出数据做准备 [打印本页]

作者: 5dm 时间: 2012-11-28 10:24
标题: 创建目录，为导出数据做准备

1.创建目录
SQL> show user;
USER is "SYS"
SQL> create directory dump_dir as '/oracle/dumps';

Directory created.

SQL> create directory log_dir as '/oracle/logs';

Directory created.

2.使用grant语句对目录授权
SQL> grant read,write on directory dump_dir to public;

SQL> grant read,write on directory log_dir to hr;

Grant succeeded.

3.查证是否创建目录成功
SQL> select * from dba_directories;

OWNER DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------
SYS DUMP_DIR
/oracle/dumps

OWNER DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS LOG_DIR
/oracle/logs

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)