{"id":274,"date":"2015-01-20T11:26:08","date_gmt":"2015-01-20T02:26:08","guid":{"rendered":"http:\/\/www.fsquare.co.kr\/?p=274"},"modified":"2015-02-18T15:59:27","modified_gmt":"2015-02-18T06:59:27","slug":"mysqlmariadb-5-5%ec%97%90-%ec%9e%88%eb%8a%94-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%a5%bc-oracleoracle-12c%eb%a1%9c-migration","status":"publish","type":"post","link":"https:\/\/www.fsquare.co.kr\/?p=274","title":{"rendered":"mysql(mariadb 5.5)\uc5d0 \uc788\ub294 \ub370\uc774\ud130\ub97c oracle(oracle 12c)\ub85c migration"},"content":{"rendered":"

mysql\uc5d0 \uc788\ub294 \ub370\uc774\ud130\ub97c oracle\ub85c migration\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc774\ubbf8 \ucd9c\uc2dc\ub418\uc5b4 \uc788\ub294 \ud234\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uac00\uc7a5 \ube60\ub974\uace0 \ud6a8\uc728\uc801\uc774\ub2e4.<\/p>\n

\uadf8\ub7ec\ub098, \uc120\ucc9c\uc801\uc73c\ub85c \uc774\ub7ec\ud55c \ud234 \ub610\ub294 \uc720\ud2f8\ub9ac\ud2f0\uc5d0 \uac70\ubd80\uac10\uc774 \uc788\uac70\ub098 \ud2b8\ub77c\uc774\uc5bc \ubc84\uc804\uc758 \uc124\uce58\uac00 \ubc88\uac70\ub86d\uac70\ub098 \ub450\ub824\uc6c0\uc774 \ub290\uaef4\uc9c0\ub294 \uacbd\uc6b0 \uc9c1\uc811 \ub370\uc774\ud130\ub97c \uc62e\uae30\ub294 \uc791\uc5c5\uc744 \uc120\ud0dd\ud55c\ub2e4.<\/p>\n

\uc9c1\uc811 \ub370\uc774\ud130\ub97c \uc62e\uae30\ub294 \ubc29\ubc95\uc740 1. phyton\uc774\ub098 php \ub4f1\uc73c\ub85c \ud504\ub85c\uadf8\ub7a8\uc744 \uc9c1\uc811 \uc9dc\uc11c mysql\uc5d0\uc11c \uc77d\uc5b4\uc11c oracle\ub85c insert \ud558\ub294 \ubc29\ubc95\uacfc 2. mysqldump\ub85c \ub370\uc774\ud130\ub97c \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc544 oracle\uc5d0\uc11c insert\ub97c \ud558\ub294 \ubc29\ubc95\uc774 \uc788\uaca0\ub2e4.<\/p>\n

1. phyton, php \ub4f1\uc73c\ub85c \uc9c1\uc811 \ud504\ub85c\uadf8\ub7a8\uc744 \uc9dc\ub294 \ubc29\ubc95<\/p>\n

\uc790\uae30\uac00 \uc798 \uc544\ub294 \ubc29\ubc95\uc73c\ub85c \uadf8\ub0e5 \ud504\ub85c\uadf8\ub7a8\uc744 \uc9dc\uc11c \ub3cc\ub9b0\ub2e4.<\/p>\n

\uc774 \ub54c \uc8fc\uc758\ud560 \uc810\uc774 \uc788\ub294\ub370 DDL, \uc989 oracle\uc758 tablespace\ub098 table, view, index, primary key \uc815\uc758 \ub4f1\uc740 mysql\uacfc \ucc28\uc774\uac00 \uc788\uae30 \ub54c\ubb38\uc5d0 \ubbf8\ub9ac \ubcc4\ub3c4\uc758 \uc2a4\ud06c\ub9bd\ud2b8\ub85c \ub2e4 \ub9cc\ub4e4\uc5b4 \ub450\uc5b4\uc57c \ud55c\ub2e4. \uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 \ud504\ub85c\uadf8\ub7a8\uc73c\ub85c tablespace, table, index \ub4f1\ub4f1\uc744 \ub9cc\ub4e4\uc5b4\uc8fc\ub294 \ud504\ub85c\uadf8\ub7a8\uc744 \uc9c1\uc811 \ub2e4 \uc791\uc131\ud574\uc57c \ud55c\ub2e4.<\/p>\n

\ub370\uc774\ud130\uc758 insert \uc2dc\uc5d0\ub3c4 \ud55c\uae00 \ubcc0\ud658\ubb38\uc81c, \uc790\ub9bf\uc218 \ubb38\uc81c, NULL \ubb38\uc81c \ub4f1\uc744 \uc0dd\uac01\ud558\uace0 \ucc98\ub9ac\ud574\uc57c\ud55c\ub2e4. mysql\uc5d0\uc11c\ub294 ”\uc744 NULL\ub85c \uc778\uc2dd\ud558\uc9c0 \uc54a\uc9c0\ub9cc oracle\uc5d0\uc11c\ub294 NULL\ub85c \uc778\uc2dd\ud55c\ub2e4.<\/p>\n

2. mysqldump\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95<\/p>\n

mysqldump -p -u userid database<\/em> tablename<\/em> > table1<\/em>.sql\u00a0<\/em> \ub4f1\uc758 \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud55c\ub2e4.<\/p>\n

\uc774 \ub54c mysqldump\ub85c dump\ub41c \ub0b4\uc6a9\uc740<\/p>\n

INSERT INTO `tablename` VALUES (value1, value2, value3, .. ), (value1, value2, value3, ... ), (value1, value2, value3, ... ), ...\r\n<\/pre>\n
\uc640 \uac19\uc774 \ub418\uc5b4 \uc788\ub2e4.<\/p>\n
\uc774\ub97c \ubcc0\ud658\ud558\uc5ec<\/p>\n
INSERT INTO `tablename` VALUES (value1, value2, value3, ... ) ;\r\nINSERT INTO `tablename` VALUES (value1, value2, value3,... );\r\n...<\/pre>\n
\uc640 \uac19\uc740 \ud615\uc2dd\uc73c\ub85c \ubcc0\ud658\ud558\ub294 \uac83\uc740 \uadc0\ucc2e\uc740 \uc791\uc5c5\uc774\ubbc0\ub85c \ub2e4\uc74c\uc758 \uc635\uc158\uc744 \uc900\ub2e4.<\/p>\n
mysqldump --skip-opt --quick\u00a0-p -u userid database<\/em> tablename<\/em> > table1<\/em>.sql .<\/em><\/pre>\n
 skip-opt \uc635\uc158 ( –skip-opt )\ub294 –add-drop-table, –add-locks, –create-options, –disable-keys, –extended-insert, –lock-tables, –quick, –set-charset \ub4f1\uc758 \uc635\uc158\uc744 \ucde8\uc18c\uc2dc\ud0a4\ub294 \uc635\uc158\uc73c\ub85c \uadf8 \uc911 extended-insert \uc635\uc158\uc744 \ud2b9\ud788 disable \uc2dc\ud0b4\uc73c\ub85c \uc368 INSERT \ubb38\uc7a5\uc774 \uac1c\ubcc4 \ubb38\uc7a5(\ud55c\uc904\uc529)\uc73c\ub85c \uc0dd\uc131\ub418\ub3c4\ub85d \ud558\uace0 drop-table \ubb38\uc7a5\uacfc create table \ubb38\uc7a5\uc744 \ud3ec\ud568\uc2dc\ud0a4\uc9c0 \uc54a\ub3c4\ub85d \ud55c\ub2e4. (\uc2e4\uc81c\ub85c\ub294 \uacc4\uc18d create table \ubb38\uc7a5\uc774 \ud3ec\ud568\ub41c\ub2e4)<\/p>\n
\uadf8\ub9ac\uace0 –quick \uc635\uc158\uc740 \ubc84\ud37c\ub97c \ud558\uc9c0 \uc54a\uace0 \ubc14\ub85c disk\uc5d0 \uc4f0\uac8c \ud568\uc73c\ub85c\uc368 \ub300\uc6a9\ub7c9 \ud14c\uc774\ube14\uc758 \uacbd\uc6b0 \uba54\ubaa8\ub9ac \uc624\ubc84\ud50c\ub85c\uc6b0\uac00 \ubc1c\uc0dd\ud558\ub294 \uac83\uc744 \ub9c9\uc544\uc900\ub2e4.<\/p>\n
\uadf8\ub807\uac8c \uc0dd\uc131\ub41c table1.sql\uc744 oracle sqlplus\uc5d0\uc11c @ \uba85\ub839\uc73c\ub85c \uc2e4\ud589\uc2dc\ucf1c\u00a0\uc8fc\uba74 \ud14c\uc774\ube14 \uba85\uc5d0 `table_name`\uacfc \uac19\uc740 ` \ubb38\uc790\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\uc5b4\uc11c \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud55c\ub2e4.<\/p>\n
\uadf8\ub798\uc11c<\/p>\n
sed -i 's\/`\/\/g' table1.sql<\/pre>\n
\uba85\ub839\uc73c\ub85c `\ubb38\uc790\ub97c \ub2e4 \uc81c\uac70\ud574 \uc900 \ub2e4\uc74c sqlplus\uc5d0\uc11c @\ub85c \uc2e4\ud589\uc2dc\ucf1c \uc900\ub2e4.<\/p>\n
 <\/p>\n
sqlplus\ub85c oracle\uc5d0 \ub370\uc774\ud130\ub97c \uc785\ub825\ud560 \ub54c & \ubb38\uc790\ub294 oracle\uc758 \uc608\uc57d\uc5b4\ub85c \ubcc0\uc218\ub97c \uc120\uc5b8\ud558\ub294 \uc608\uc57d\uc5b4\uc774\ub2e4.<\/p>\n
\ub9cc\uc57d \ub370\uc774\ud130 \ub0b4\uc5d0 & \ubb38\uc790\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\ub2e4\uba74 (\uc608\ub97c \ub4e4\uc5b4 ‘School & Campus \uc640 \uac19\uc774 ) insert\ub97c \ud558\ub2e4\uac00 \uac11\uc790\uae30 \ubcc0\uc218\uac12\uc744 \uc785\ub825\uc744 \ubc1b\uae30 \uc704\ud55c \ud504\ub86c\ud504\ud2b8 \uc0c1\ud0dc\uac00 \ub418\uc5b4 \ubc84\ub9b0\ub2e4.<\/p>\n
\uc774\ub7f0 \uc0c1\ud0dc\ub97c \ubc29\uc9c0\ud558\uae30 \uc704\ud574\uc11c\ub294 table1.sql\u00a0\ud30c\uc77c \uccab \uba38\ub9ac\uc5d0<\/p>\n
SET DEFINE OFF;\u00a0\r\nSET AUTOCOMMIT 1000;<\/pre>\n
\ub97c \ucd94\uac00\ud574 \uc8fc\uc5b4\uc57c \ud55c\ub2e4.<\/p>\n
SET AUTOCOMMIT 1000;\uc740 1000 line \ub9c8\ub2e4 commit\uc744 \ud574 \uc8fc\ub3c4\ub85d \ud55c\ub2e4. \ub9cc\uc57d AUTOCOMMIT\uc774 \uc548\ub418\uba74 \ubaa8\ub4e0 INSERT \ubb38\uc740 rollback \uac00\ub2a5\ud55c \uc0c1\ud0dc\ub85c undo tablespace\uc5d0 \uc800\uc7a5\ub418\uace0\u00a0\uc18d\ub3c4\uac00 \uc810\uc810 \ub290\ub824\uc9c4\ub2e4.<\/p>\n
\ud55c\uae00 \ubb38\uc81c<\/strong><\/h1>\n
\ub370\uc774\ud130 \uc774\uc804\uc2dc \ud55c\uae00 \ubb38\uc81c\ub294 \uc5ec\ub7ec\ubaa8\ub85c \uace8\uce58\ub97c \uc369\ud788\ub294 \uc77c\uc774\ub2e4. \ud2b9\ud788 mysql\uc744 \ud328\ud0a4\uc9c0\ub85c \uc124\uce58\ud558\uace0 \uadf8\ub0e5 \uc4f0\ub294 \uacbd\uc6b0 table\uc758 \ubb38\uc790\uc14b\uc744 latin1\uc73c\ub85c \uadf8\ub0e5 \ub454 \uacbd\uc6b0 default-char-set\uc744 latin1\uc73c\ub85c \uc9c0\uc815\ud574\uc57c \ud55c\uae00\uc774 \uc815\uc0c1\uc801\uc73c\ub85c \ucd94\ucd9c\ub418\uace0 oracle \ud55c\uae00 \uc785\ub825\ub3c4 \ub2e4\uc591\ud55c \ud30c\ub77c\ubbf8\ud130( LANG, NLS_LANG, NLS_CHARACTER \ub4f1\ub4f1)\ub97c \uc124\uc815\ud574\uc57c \ud558\ubbc0\ub85c \ud14c\uc2a4\ud2b8\ub97c \ucda9\ubd84\ud788 \ud574 \ubcf4\uace0 migration\ud574\uc57c \ud560 \uac83\uc774\ub2e4.<\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
mysql\uc5d0 \uc788\ub294 \ub370\uc774\ud130\ub97c oracle\ub85c migration\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc774\ubbf8 \ucd9c\uc2dc\ub418\uc5b4 \uc788\ub294 \ud234\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uac00\uc7a5 \ube60\ub974\uace0 \ud6a8\uc728\uc801\uc774\ub2e4. \uadf8\ub7ec\ub098, \uc120\ucc9c\uc801\uc73c\ub85c \uc774\ub7ec\ud55c \ud234 \ub610\ub294 \uc720\ud2f8\ub9ac\ud2f0\uc5d0 \uac70\ubd80\uac10\uc774 \uc788\uac70\ub098 \ud2b8\ub77c\uc774\uc5bc \ubc84\uc804\uc758 \uc124\uce58\uac00 \ubc88\uac70\ub86d\uac70\ub098 \ub450\ub824\uc6c0\uc774 \ub290\uaef4\uc9c0\ub294 \uacbd\uc6b0 \uc9c1\uc811 \ub370\uc774\ud130\ub97c \uc62e\uae30\ub294 \uc791\uc5c5\uc744 \uc120\ud0dd\ud55c\ub2e4. \uc9c1\uc811 \ub370\uc774\ud130\ub97c \uc62e\uae30\ub294 \ubc29\ubc95\uc740 1. phyton\uc774\ub098 php \ub4f1\uc73c\ub85c \ud504\ub85c\uadf8\ub7a8\uc744 \uc9c1\uc811 \uc9dc\uc11c mysql\uc5d0\uc11c \uc77d\uc5b4\uc11c oracle\ub85c insert \ud558\ub294 \ubc29\ubc95\uacfc 2. mysqldump\ub85c \ub370\uc774\ud130\ub97c […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,9],"tags":[],"class_list":["post-274","post","type-post","status-publish","format-standard","hentry","category-it","category-linux"],"_links":{"self":[{"href":"https:\/\/www.fsquare.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/274","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fsquare.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fsquare.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fsquare.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fsquare.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=274"}],"version-history":[{"count":10,"href":"https:\/\/www.fsquare.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/274\/revisions"}],"predecessor-version":[{"id":285,"href":"https:\/\/www.fsquare.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/274\/revisions\/285"}],"wp:attachment":[{"href":"https:\/\/www.fsquare.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=274"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fsquare.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=274"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fsquare.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=274"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}