Category Archives: db

Create Directory CREATE OR REPLACE DIRECTORY MY_LOG_DIR AS ‘/opt/oracle/dataload/logs’; List All My Directories col OWNER format a9 col DIRECTORY_NAME format a9 col DIRECTORY_PATH format a29   SELECT * FROM all_directories WHERE directory_name LIKE ‘MY%’; Grant Access to Directory GRANT READ … Continue reading →