{"id":429,"date":"2013-10-23T09:49:43","date_gmt":"2013-10-23T18:49:43","guid":{"rendered":"\/blog\/?p=429"},"modified":"2023-09-21T09:38:50","modified_gmt":"2023-09-21T00:38:50","slug":"oracle-expdp-%eb%94%94%eb%a0%89%ed%86%a0%eb%a6%ac-%eb%b3%80%ea%b2%bd","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=429","title":{"rendered":"Oracle expdp \ub514\ub809\ud1a0\ub9ac \ubcc0\uacbd"},"content":{"rendered":"\n

SELECT * FROM DBA_DIRECTORIES;<\/span><\/strong><\/span><\/p>\n

OWNER<\/span>
------------------------------------------------------------<\/span>
DIRECTORY_NAME<\/span>
------------------------------------------------------------<\/span>
DIRECTORY_PATH<\/span>
--------------------------------------------------------------------------------<\/span>
SYS<\/span>
BACKUP<\/span>
\/var\/backup<\/span><\/p>\n

SYS<\/span>
SUBDIR<\/span>
\/opt\/gate1\/Engine\/oracle\/11g\/demo\/schema\/order_entry\/\/2002\/Sep<\/span><\/p>\n

OWNER<\/span>
------------------------------------------------------------<\/span>
DIRECTORY_NAME<\/span>
------------------------------------------------------------<\/span>
DIRECTORY_PATH<\/span>
--------------------------------------------------------------------------------<\/span><\/p>\n

SYS<\/span>
SS_OE_XMLDIR<\/span>
\/opt\/gate1\/Engine\/oracle\/11g\/demo\/schema\/order_entry\/<\/span><\/p>\n

SYS<\/span>
LOG_FILE_DIR<\/span><\/p>\n

OWNER<\/span>
------------------------------------------------------------<\/span>
DIRECTORY_NAME<\/span>
------------------------------------------------------------<\/span>
DIRECTORY_PATH<\/span>
--------------------------------------------------------------------------------<\/span>
\/opt\/gate1\/Engine\/oracle\/11g\/demo\/schema\/log\/<\/span><\/p>\n

SYS<\/span>
DATA_FILE_DIR<\/span>
\/opt\/gate1\/Engine\/oracle\/11g\/demo\/schema\/sales_history\/<\/span><\/p>\n

SYS<\/span><\/p>\n

OWNER<\/span>
------------------------------------------------------------<\/span>
DIRECTORY_NAME<\/span>
------------------------------------------------------------<\/span>
DIRECTORY_PATH<\/span>
--------------------------------------------------------------------------------<\/span>
XMLDIR<\/span>
\/ade\/b\/1191423112\/oracle\/rdbms\/xml<\/span><\/p>\n

SYS<\/span>
MEDIA_DIR<\/span>
\/opt\/gate1\/Engine\/oracle\/11g\/demo\/schema\/product_media\/<\/span><\/p>\n


OWNER<\/span>
------------------------------------------------------------<\/span>
DIRECTORY_NAME<\/span>
------------------------------------------------------------<\/span>
DIRECTORY_PATH<\/span>
--------------------------------------------------------------------------------<\/span>
SYS<\/span>
DATA_PUMP_DIR<\/span>
\/opt\/db\/app\/oracle\/admin\/GATEONE\/dpdump<\/span><\/p>\n

SYS<\/span>
ORACLE_OCM_CONFIG_DIR<\/span>
\/opt\/db\/app\/oracle\/11g\/ccr\/state<\/span><\/p>\n

OWNER<\/span>
------------------------------------------------------------<\/span>
DIRECTORY_NAME<\/span>
------------------------------------------------------------<\/span>
DIRECTORY_PATH<\/span>
--------------------------------------------------------------------------------<\/span><\/p>\n


9 rows selected.<\/span><\/p>\n


CREATE OR REPLACE DIRECTORY  SUBDIR AS '\/opt\/db\/app\/oracle\/11g\/demo\/schema\/order_entry\/\/2002\/Sep';<\/span>
CREATE OR REPLACE DIRECTORY  SS_OE_XMLDIR AS '\/opt\/db\/app\/oracle\/11g\/demo\/schema\/order_entry\/';<\/span>
CREATE OR REPLACE DIRECTORY  LOG_FILE_DIR AS '\/opt\/db\/app\/oracle\/11g\/demo\/schema\/log\/';<\/span>
CREATE OR REPLACE DIRECTORY  DATA_FILE_DIR AS '\/opt\/db\/app\/oracle\/11g\/demo\/schema\/sales_history\/';<\/span>
CREATE OR REPLACE DIRECTORY  MEDIA_DIR AS '\/opt\/db\/app\/oracle\/11g\/demo\/schema\/product_media\/';<\/span>
<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

SELECT * FROM DBA_DIRECTORIES; OWNER————————————————————DIRECTORY_NAME————————————————————DIRECTORY_PATH——————————————————————————–SYSBACKUP\/var\/backup SYSSUBDIR\/opt\/gate1\/Engine\/oracle\/11g\/demo\/schema\/order_entry\/\/2002\/Sep OWNER————————————————————DIRECTORY_NAME————————————————————DIRECTORY_PATH——————————————————————————– SYSSS_OE_XMLDIR\/opt\/gate1\/Engine\/oracle\/11g\/demo\/schema\/order_entry\/ SYSLOG_FILE_DIR OWNER————————————————————DIRECTORY_NAME————————————————————DIRECTORY_PATH——————————————————————————–\/opt\/gate1\/Engine\/oracle\/11g\/demo\/schema\/log\/ SYSDATA_FILE_DIR\/opt\/gate1\/Engine\/oracle\/11g\/demo\/schema\/sales_history\/ SYS OWNER————————————————————DIRECTORY_NAME————————————————————DIRECTORY_PATH——————————————————————————–XMLDIR\/ade\/b\/1191423112\/oracle\/rdbms\/xml SYSMEDIA_DIR\/opt\/gate1\/Engine\/oracle\/11g\/demo\/schema\/product_media\/ OWNER————————————————————DIRECTORY_NAME————————————————————DIRECTORY_PATH——————————————————————————–SYSDATA_PUMP_DIR\/opt\/db\/app\/oracle\/admin\/GATEONE\/dpdump SYSORACLE_OCM_CONFIG_DIR\/opt\/db\/app\/oracle\/11g\/ccr\/state OWNER————————————————————DIRECTORY_NAME————————————————————DIRECTORY_PATH——————————————————————————– 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\/’;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-429","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/429","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=429"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/429\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=429"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}