Directories

To check directories
col DIRECTORY_NAME format a35
col DIRECTORY_PATH format a40
select * from dba_directories;

To check Privileges
col GRANTOR format a12
col GRANTEE format a20

col TABLE_NAME format a30
col TABLE_SCHEMA format a20
set line 400
set pagesize 50
select * from all_tab_privs where table_name in
(select directory_name from dba_directories);

To grant privilege
GRANT read, write ON DIRECTORY agap TO rman;

To create Directory
CREATE DIRECTORY bfile_dir AS '/usr/bin/bfile_dir';

CREATE OR REPLACE DIRECTORY bfile_dir AS '/usr/bin/bfile_dir';