Meta
Categories
Tag Archives: oracle
Oracle Directory
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