创建目录，为导出数据做准备

5dm

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