[Oracle] Oracle Directory 조회 / 생성 및 권한 부여

Oracle Directory

Oracle Directory 조회

SELECT DIRECTORY_NAME, DIRECTORY_PATH
FROM DBA_DIRECTORIES
ORDER BY DIRECTORY_NAME;

Oracle Directory 생성 및 권한 부여

CREATE OR REPLACE DIRECTORY DATA_PUMP_DIR AS '~~~~~~\dpdump';

GRANT READ, WRITE ON DIRECTORY DATA_PUMP_DIR TO USER;