Oracle expdp 디렉토리 변경 – 뿡뿡너구리의 블로그

SELECT * FROM DBA_DIRECTORIES;

OWNER
------------------------------------------------------------
DIRECTORY_NAME
------------------------------------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS
BACKUP
/var/backup

SYS
SUBDIR
/opt/gate1/Engine/oracle/11g/demo/schema/order_entry//2002/Sep

SYS
SS_OE_XMLDIR
/opt/gate1/Engine/oracle/11g/demo/schema/order_entry/

SYS
LOG_FILE_DIR

SYS
DATA_FILE_DIR
/opt/gate1/Engine/oracle/11g/demo/schema/sales_history/

SYS

SYS
MEDIA_DIR
/opt/gate1/Engine/oracle/11g/demo/schema/product_media/

SYS
ORACLE_OCM_CONFIG_DIR
/opt/db/app/oracle/11g/ccr/state

9 rows selected.

CREATE OR REPLACE DIRECTORY SUBDIR AS '/opt/db/app/oracle/11g/demo/schema/order_entry//2002/Sep';
CREATE OR REPLACE DIRECTORY SS_OE_XMLDIR AS '/opt/db/app/oracle/11g/demo/schema/order_entry/';
CREATE OR REPLACE DIRECTORY LOG_FILE_DIR AS '/opt/db/app/oracle/11g/demo/schema/log/';
CREATE OR REPLACE DIRECTORY DATA_FILE_DIR AS '/opt/db/app/oracle/11g/demo/schema/sales_history/';
CREATE OR REPLACE DIRECTORY MEDIA_DIR AS '/opt/db/app/oracle/11g/demo/schema/product_media/';