{"id":807,"date":"2015-12-20T11:41:13","date_gmt":"2015-12-20T11:41:13","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=807"},"modified":"2015-12-20T11:41:13","modified_gmt":"2015-12-20T11:41:13","slug":"datapump-%ec%82%ac%ec%9a%a9%ec%8b%9c-version-%ed%8c%8c%eb%9d%bc%eb%af%b8%ed%84%b0%ec%97%90-%eb%8c%80%ed%95%9c-%ec%a3%bc%ec%9d%98%ec%82%ac%ed%95%ad","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=807","title":{"rendered":"Datapump \uc0ac\uc6a9\uc2dc Version \ud30c\ub77c\ubbf8\ud130\uc5d0 \ub300\ud55c \uc8fc\uc758\uc0ac\ud56d"},"content":{"rendered":"

# \uc6b0\ub9ac\ub294 Datapump\ub97c \uc0ac\uc6a9\uc2dc DB\uc758 \ubc84\uc804\uc774 \ub0ae\uc740 -> \ub192\uc740, \ub192\uc740 -> \ub0ae\uc740 \ubc84\uc804\uc73c\ub85c Datapump\ub97c \uc2e4\uc2dc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\uc774\ub7f4 \uacbd\uc6b0\uc5d0 version\uc774\ub77c\ub294 \ud30c\ub77c\ubbf8\ud130\uc5d0 \ub300\ud574 \uc774\ud574\uac00 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n

1. Datapump dumpfile compatibility(EXPDP \ud560 \ub54c \uba85\uc2dc\ud558\uc5ec\uc57c\ud560 \uac83)<\/p>\n

<\/p>\n

<\/p>\n

<\/p>\n

<\/p>\n

\uc608\ub97c \ub4e4\uc5b4 Expdp \ud558\ub294 DB\uc758 \ubc84\uc804\uc774 12.1\uc77c\ub54c 10.2\uc758 DB\uc5d0 impdp \ud558\ub824\uba74, expdp \ud560\ub54c VERSION=10.2\ub97c \uba85\uc2dc\ud574\uc918\uc57c \ud55c\ub2e4\ub294 \ub0b4\uc6a9\uc785\ub2c8\ub2e4.<\/p>\n

<\/p>\n

10.2\uc5d0\uc11c expdp\ud558\uc5ec 10.2\uc5d0 \ub123\ub294\ub2e4\uba74 \ubc84\uc804\uc774 \uac19\uae30 \ub54c\ubb38\uc5d0 \ub530\ub85c \uba85\uc2dc\ud574\uc904 \ud544\uc694\ub294 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n

<\/p>\n

\uc5ec\uae30\uc5d0\uc11c Compatible\uc758 \uacbd\uc6b0 pfile \ubc0f spfile(show parameter compatible)\uc5d0\uc11c \ud574\ub2f9 \ubc84\uc804\uc744 \ud655\uc778\ud558\uba74 \ub429\ub2c8\ub2e4.<\/p>\n

<\/p>\n

2. dumpfile\uc758 \uc815\ubcf4 \ubcf4\ub294\ubc95<\/p>\n

DB \uc11c\ubc84\uc5d0\uc11c .dmp\ub85c \uc800\uc7a5\ud558\uc5ec Datapump\ubc1b\uc740 \ud30c\uc77c\ub4e4\uc740 \ub9ce\uc740\ub370, \ud574\ub2f9 \ud30c\uc77c\uc774 \uc5b8\uc81c \ubc1b\uc544\uc84c\uace0, \uc5b4\ub5a4 \ubc29\uc2dd\uc73c\ub85c \ubc1b\uc544\uc84c\ub294\uc9c0 \ud655\uc778\ud560 \ub54c \uc720\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n

SET serveroutput on SIZE 1000000
exec show_dumpfile_info(p_dir=> ‘my_dir’, p_file=> ‘expdp_f.dmp’)<\/p>\n

—————————————————————————-
Purpose..: Obtain details about export dumpfile.        Version: 18-DEC-2013
Required.: RDBMS version: 10.2.0.1.0 or higher
.          Export dumpfile version: 7.3.4.0.0 or higher
.          Export Data Pump dumpfile version: 10.1.0.1.0 or higher
Usage….: execute show_dumfile_info(‘DIRECTORY’, ‘DUMPFILE’);
Example..: exec show_dumfile_info(‘MY_DIR’, ‘expdp_s.dmp’)
—————————————————————————-
Filename.: expdp_f.dmp
Directory: my_dir
Disk Path: \/bugmnt1\/em\/celclnx14\/SR3.7997287101\/user\/expdp
Filetype.: 1 (Export Data Pump dumpfile)
—————————————————————————-
…Database Job Version……….: 12.01.00.00.00
…Internal Dump File Version….: 4.1 (Oracle12c Release 1: 12.1.0.x)
…Creation Date……………..: Wed May 28 07:57:24 2014
…File Number (in dump file set): 1
…Master Present in dump file…: 1 (Yes)
…Master in how many dump files.: 1
…Master Piece Number in file…: 1
…Operating System of source db.: x86_64\/Linux 2.4.xx
…Instance Name of source db….: TARMH
…Characterset ID of source db..: 871 (UTF8)
…Language Name of characterset.: UTF8
…Job Name………………….: “SYS”.”SYS_EXPORT_FULL_01″
…GUID (unique job identifier)..: FA721C2C84DB5E94E0437108DC0AF5E6
…Block size dump file (bytes)..: 4096
…Metadata Compressed………..: 1 (Yes)
…Data Compressed……………: 0 (No)
…Compression Algorithm………: 3 (Basic)
…Metadata Encrypted…………: 0 (No)
…Table Data Encrypted……….: 0 (No)
…Column Data Encrypted………: 0 (No)
…Encryption Mode……………: 2 (None)
…Internal Flag Values……….: 514
…Max Items Code (Info Items)…: 23
—————————————————————————-<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

<\/p>\n

3. \ucc38\uace0\ubb38\uc11c(support.oracle.com)<\/p>\n

Export\/Import DataPump Parameter VERSION – Compatibility of Data Pump Between Different Oracle Versions [Video] (\ubb38\uc11c ID 553337.1)<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

# \uc6b0\ub9ac\ub294 Datapump\ub97c \uc0ac\uc6a9\uc2dc DB\uc758 \ubc84\uc804\uc774 \ub0ae\uc740 -> \ub192\uc740, \ub192\uc740 -> \ub0ae\uc740 \ubc84\uc804\uc73c\ub85c Datapump\ub97c \uc2e4\uc2dc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7f4 \uacbd\uc6b0\uc5d0 version\uc774\ub77c\ub294 \ud30c\ub77c\ubbf8\ud130\uc5d0 \ub300\ud574 \uc774\ud574\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. 1. Datapump dumpfile compatibility(EXPDP \ud560 \ub54c \uba85\uc2dc\ud558\uc5ec\uc57c\ud560 \uac83) \uc608\ub97c \ub4e4\uc5b4 Expdp \ud558\ub294 DB\uc758 \ubc84\uc804\uc774 12.1\uc77c\ub54c 10.2\uc758 DB\uc5d0 impdp \ud558\ub824\uba74, expdp \ud560\ub54c VERSION=10.2\ub97c \uba85\uc2dc\ud574\uc918\uc57c \ud55c\ub2e4\ub294 \ub0b4\uc6a9\uc785\ub2c8\ub2e4. 10.2\uc5d0\uc11c expdp\ud558\uc5ec 10.2\uc5d0 \ub123\ub294\ub2e4\uba74 \ubc84\uc804\uc774 \uac19\uae30 […]<\/p>\n","protected":false},"author":1,"featured_media":808,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[10],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile23.uf.25132A4356769434271FE9.jpg?fit=723%2C247","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/807"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=807"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/807\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/808"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=807"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=807"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}