{"id":445,"date":"2013-12-15T13:13:31","date_gmt":"2013-12-15T22:13:31","guid":{"rendered":"\/blog\/?p=445"},"modified":"2023-09-21T09:38:48","modified_gmt":"2023-09-21T00:38:48","slug":"impdp-remap_schema","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=445","title":{"rendered":"impdp REMAP_SCHEMA"},"content":{"rendered":"\n

sqlplus S_GATEONE\/12345678<\/span>
CREATE DIRECTORY DPDUMP_DIR AS '\/opt\/backup\/dpdump';<\/span>
GRANT READ, WRITE ON DIRECTORY DPDUMP_DIR TO S_GATEONE;<\/span>

export ORACLE_SID=GATEONE<\/span>
CREATE USER GATEONE IDENTIFIED BY \"121234434\";<\/span>
GRANT CONNECT,RESOURCE,DBA TO GATEONE;<\/span>

impdp S_GATEONE\/12345678 \\<\/span>
dumpfile=gateone.dmp directory=DPDUMP_DIR \\<\/span>
logfile=impd_gateone.log \\<\/span>
TABLE_EXISTS_ACTION=APPEND REMAP_SCHEMA=GATEONE:S_GATEONE \\<\/span>
REMAP_TABLESPACE=GATEONE:TS_GATEONE<\/span>

DROP USER GATEONE CASCADE;<\/span>

---------------------------------------------------------------------<\/span>

export ORACLE_SID=HA<\/span>
CREATE USER GATEONE IDENTIFIED BY \"121234434\";<\/span>
GRANT CONNECT,RESOURCE,DBA TO GATEONE;<\/span>

impdp S_GATEONE\/12345678 \\<\/span>
dumpfile=ha.dmp directory=DPDUMP_DIR \\<\/span>
logfile=impd_ha.log \\<\/span>
TABLE_EXISTS_ACTION=APPEND REMAP_SCHEMA=GATEONE:S_GATEONE \\<\/span>
REMAP_TABLESPACE=HA:TS_HA<\/span>

DROP USER GATEONE CASCADE;<\/span>
<\/p>\n","protected":false},"excerpt":{"rendered":"

sqlplus S_GATEONE\/12345678CREATE DIRECTORY DPDUMP_DIR AS ‘\/opt\/backup\/dpdump’;GRANT READ, WRITE ON DIRECTORY DPDUMP_DIR TO S_GATEONE; export ORACLE_SID=GATEONECREATE USER GATEONE IDENTIFIED BY “121234434”;GRANT CONNECT,RESOURCE,DBA TO GATEONE; impdp S_GATEONE\/12345678 \\dumpfile=gateone.dmp directory=DPDUMP_DIR \\logfile=impd_gateone.log \\TABLE_EXISTS_ACTION=APPEND REMAP_SCHEMA=GATEONE:S_GATEONE \\REMAP_TABLESPACE=GATEONE:TS_GATEONE DROP USER GATEONE CASCADE; ——————————————————————— export ORACLE_SID=HACREATE USER GATEONE IDENTIFIED BY “121234434”;GRANT CONNECT,RESOURCE,DBA TO GATEONE; impdp S_GATEONE\/12345678 \\dumpfile=ha.dmp directory=DPDUMP_DIR \\logfile=impd_ha.log \\TABLE_EXISTS_ACTION=APPEND REMAP_SCHEMA=GATEONE:S_GATEONE \\REMAP_TABLESPACE=HA:TS_HA DROP […]<\/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-445","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\/445","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=445"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/445\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=445"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}