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
|