오라클 디렉토리 만들기

오라클 디렉토리 생성

CREATE DIRECTORY 디렉토리명 AS '디렉토리경로';

GRANT READ ON DIRECTORY 디렉토리명 TO PUBLIC;  --읽기권한 
GRANT WRITE ON DIRECTORY 디렉토리명 TO PUBLIC; --쓰기권한

오라클 디렉토리 삭제

DROP DIRECTORY 디렉토리명;

오라클 디렉토리 조회

select OWNER,
       DIRECTORY_NAME,
       DIRECTORY_PATH
from DBA_DIRECTORIES

오라클 디렉토리 결과

OWNER|DIRECTORY_NAME       |DIRECTORY_PATH                                                      |
-----|---------------------|--------------------------------------------------------------------|
SYS  |SUBDIR               |D:\app\GEO\product\11.2.0\dbhome_1\demo\schema\order_entry\/2002/Sep|
SYS  |SS_OE_XMLDIR         |D:\app\GEO\product\11.2.0\dbhome_1\demo\schema\order_entry\         |
SYS  |LOG_FILE_DIR         |D:\app\GEO\product\11.2.0\dbhome_1\demo\schema\log\                 |
SYS  |DATA_FILE_DIR        |D:\app\GEO\product\11.2.0\dbhome_1\demo\schema\sales_history\       |
SYS  |XMLDIR               |c:\ade\aime_dadvfm0254\oracle\rdbms\xml                             |
SYS  |MEDIA_DIR            |D:\app\GEO\product\11.2.0\dbhome_1\demo\schema\product_media\       |
SYS  |DATA_PUMP_DIR        |D:\app\GEO\admin\orcl\dpdump\                                       |
SYS  |ORACLE_OCM_CONFIG_DIR|D:\app\GEO\product\11.2.0\dbhome_1\ccr\state                        |