{"id":4246,"date":"2019-01-15T14:19:17","date_gmt":"2019-01-15T05:19:17","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=4246"},"modified":"2019-01-15T14:34:40","modified_gmt":"2019-01-15T05:34:40","slug":"oracle-gateway-%ec%9d%b4%ea%b8%b0%ec%a2%85-db-link","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=4246","title":{"rendered":"Oracle Gateway \uc774\uae30\uc885 DB Link"},"content":{"rendered":"<div class=\"Section1\" style=\"-ms-layout-grid: both loose 18pt 0pt; line-height: normal; mso-layout-grid-char-alt: 0;\"><\/div>\n<p><span lang=\"EN-US\" style=\"line-height: normal; mso-bidi-font-size: 12.0pt; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: en-us; mso-fareast-language: ko; mso-bidi-language: ar-sa;\">\u00a0<\/span><\/p>\n<h1 style=\"margin: 0cm 0cm 0pt 27.75pt; line-height: normal; text-indent: -27.75pt; padding-bottom: 0px; -ms-text-justify: inter-ideograph;\" align=\"justify\"><\/h1>\n<h1><a name=\"_Toc359000542\"><\/a>1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Gateway \uac1c\uc694<\/h1>\n<p>n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \uc774\uae30\uc885 Database \uac04\uc758 \ud1b5\uc2e0\uc744 \uc704\ud574\uc11c \uc624\ub77c\ud074\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \uc81c\ud488\uc774\ub2e4.<\/p>\n<p>n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \uc774\uae30\uc885 \uc2dc\uc2a4\ud15c \uac04\uc758 SQL \ubcc0\ud658, \ub370\uc774\ud130\uc758 \uc6d0\ud65c\ud55c \uc0c1\ud638 \uc6b4\uc601\uc131\uc744 \uc81c\uacf5\ud55c\ub2e4<\/p>\n<p>n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Oracle 9i \ubc84\uc804\ubd80\ud130 CD\uc5d0 \ud3ec\ud568\ub418\uc5b4 \uc81c\uacf5\ub418\uace0 \uc788\uc73c\uba70 Gateway \uc11c\ube44\uc2a4\ub97c \uc81c\uacf5 \ubc1b\uc73c\ub824\uba74 \ubcc4\ub3c4\uc758 \ub77c\uc774\uc120\uc2a4\ub97c \uad6c\ub9e4\ud574\uc57c \ud55c\ub2e4<\/p>\n<p>&nbsp;<\/p>\n<h1><a name=\"_Toc359000543\"><\/a>2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Gateway \uc6d0\ub9ac<\/h1>\n<ul>\n<li>\uc774\uae30\uc885\uac04 \uc11c\ube44\uc2a4(Heterogeneous Connectivity)\uc5d0 \uc758\ud574 Oracle SQL \uc744 Oracle \uc774\uc678\uc758 \uc2dc\uc2a4\ud15c\uc758 \uc801\uc808\ud55c \uc5b8\uc5b4\ub85c \ubcc0\ud658\ud558\ub294 \uae30\ub2a5\uacfc Oracle \uc774\uc678\uc758 \uc2dc\uc2a4\ud15c\uc758 \uba54\ud0c0\ub370\uc774\ud0c0\ub97c \ub85c\uceec \uc11c\uc2dd\uc5d0\uc11c \ub098\ud0c0\ub0b4\ub294\ub370\uc774\ud130\u00b7\ub515\uc154\ub108\ub9ac \ubcc0\ud658\uc758 2 \uc885\ub958\uc758 \ubcc0\ud658\uc774 \uc81c\uacf5\ub41c\ub2e4. \ubcc0\ud658\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub294 \uacbd\uc6b0\uc5d0\ub294 pass-through \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud574 Oracle \uc774\uc678\uc758 \uc2dc\uc2a4\ud15c\uc5d0 \uc2dc\uc2a4\ud15c \uace0\uc720\uc758 SQL\ubb38\uc744 \uc2e4\ud589\ud560 \uc218 \uc788\ub2e4.<\/li>\n<\/ul>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 20pt; line-height: normal; -ms-text-justify: inter-ideograph;\" align=\"justify\"><span style=\"left: 0px; width: 275px; height: 17px; margin-top: 383px; margin-left: 192px; position: absolute; z-index: 2; mso-ignore: vglayout;\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0014.gif\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image001[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0014_thumb.gif?resize=275%2C17\" alt=\"clip_image001[4]\" width=\"275\" height=\"17\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span lang=\"EN-US\" style=\"line-height: normal;\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0034.jpg\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image003[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0034_thumb.jpg?resize=640%2C401\" alt=\"clip_image003[4]\" width=\"640\" height=\"401\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 20pt; line-height: normal; -ms-text-justify: inter-ideograph;\" align=\"justify\"><span lang=\"EN-US\"><span style=\"font-size: 10pt;\">\u00a0<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 20pt; line-height: normal; -ms-text-justify: inter-ideograph;\" align=\"justify\"><span lang=\"EN-US\"><span style=\"font-size: 10pt;\">\u00a0<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<h1 style=\"margin: 0cm 0cm 0pt 27.75pt; line-height: normal; text-indent: -27.75pt; padding-bottom: 0px; -ms-text-justify: inter-ideograph;\" align=\"justify\"><a name=\"_Toc359000544\"><\/a><span lang=\"EN-US\" style=\"mso-fareast-font-family: arial;\"><span style=\"mso-list: ignore;\"><span style=\"font-size: 16pt;\">3<\/span><span style=\"line-height: normal; font-size-adjust: none; font-stretch: normal;\"><span style=\"font-size: 7pt;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span><span lang=\"EN-US\"><span style=\"font-size: 16pt;\">T<\/span><\/span><\/h1>\n<h1><a name=\"_Toc359000544\"><\/a>1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TEST \ubaa9\uc801<\/h1>\n<ul>\n<li>Oracle Gateway \uc81c\ud488\uc744 \uc774\uc6a9\ud558\uc5ec \uc774\uae30\uc885 DB\ub97c \uc5f0\ub3d9\uc2dc\ud0a8\ub2e4<\/li>\n<li>Gateway\ub85c \uc5f0\uacb0\ub41c \uc0c1\ud638 DB\uac04\uc5d0 \ub370\uc774\ud130 \uc870\ud68c(select )<\/li>\n<li>Gateway\ub85c \uc5f0\uacb0\ub41c \uc0c1\ud638 DB\uac04\uc5d0 \ub370\uc774\ud130 \uc774\ud589 (migration)<\/li>\n<li>\ubcf8 \ubb38\uc11c\uc5d0\ub294 Oracle \u2013 DB2 , Oracle \u2013 Sybase \ub450\uac00\uc9c0 \ucf00\uc774\uc2a4\ub97c \uae30\uc220\ud558\uc600\ub2e4<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h1><a name=\"_Toc359000545\"><\/a>2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TEST \ud658\uacbd\uad6c\uc131<\/h1>\n<h2><a name=\"_Toc359000546\"><\/a>2.1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Oracle DB \uc815\ubcf4<\/h2>\n<p>n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VMware Workstation 8.0<\/p>\n<p>n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 O\/S : OEL 5 64bit (Mem 2GB)<\/p>\n<p>n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Host Name : park32 (192.168.1.14)<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"595\">SQL&gt; select * from v$version;<\/p>\n<p>BANNER<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/p>\n<p>Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 &#8211; 64bit Production<\/p>\n<p>PL\/SQL Release 11.2.0.3.0 &#8211; Production<\/p>\n<p>CORE\u00a0\u00a0\u00a0 11.2.0.3.0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Production<\/p>\n<p>TNS for Linux: Version 11.2.0.3.0 &#8211; Production<\/p>\n<p>NLSRTL Version 11.2.0.3.0 &#8211; Production<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h2><a name=\"_Toc359000547\"><\/a>2.2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DB2 DB \uc815\ubcf4<\/h2>\n<p>n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VMware Workstation 8.0<\/p>\n<p>n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 O\/S : OEL 5 64bit (Mem 2GB)<\/p>\n<p>n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Host Name : unione (192.168.1.9)<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"595\">[db2inst1@unione ~]$ db2level<\/p>\n<p>DB21085I\u00a0 This instance or install (instance name, where applicable:<\/p>\n<p>&#8220;db2inst1&#8221;) uses &#8220;64&#8221; bits and DB2 code release &#8220;SQL10012&#8221; with level<\/p>\n<p>identifier &#8220;0203010E&#8221;.<\/p>\n<p>Informational tokens are &#8220;DB2 v10.1.0.2&#8221;, &#8220;s121127&#8221;, &#8220;IP23394&#8221;, and Fix Pack &#8220;2&#8221;.<\/p>\n<p>Product is installed at &#8220;\/opt\/ibm\/db2\/V10.1&#8221;.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h2><a name=\"_Toc359000548\"><\/a>2.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Sybase DB \uc815\ubcf4<\/h2>\n<p>n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VMware Workstation 8.0<\/p>\n<p>n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 O\/S : OEL 5 64bit (Mem 2GB)<\/p>\n<p>n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Host Name : unione (192.168.1.9)<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"595\">[\/sybase] $isql -Usa -Psybase -Sunione<\/p>\n<p>1&gt; select @@version<\/p>\n<p>2&gt;go\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<\/p>\n<p>Adaptive Server Enterprise\/15.7.0\/EBF 20373 SMP ESD#02 \/P\/x86_64\/Enterprise<\/p>\n<p>Linux\/ase157esd2\/3109\/64-bit\/FBO\/Sat Jul\u00a0 7 05:36:19 2012<\/p>\n<p>(1 row affected)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h1><a name=\"_Toc359000549\"><\/a>3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Oracle Gateway \uc124\uce58<\/h1>\n<p>n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Oracle Database \uac00 \uc124\uce58\ub418\uc5b4 \uc788\ub294 \uc11c\ubc84\uc5d0 Gateway \uc81c\ud488\uc744 \uc124\uce58\ud55c\ub2e4<\/p>\n<p>n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \uc124\uce58 \ud30c\uc77c : p10404530_112030_Linux-x86-64_5of7.zip<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"595\">[test1:\/oracle]$ cd media\/gateways<\/p>\n<p>[test1:\/oracle\/media\/gateways]$ ls -la<\/p>\n<p>total 68<\/p>\n<p>drwxr-xr-x\u00a0 7 oracle dba\u00a0 4096 Sep 22\u00a0 2011 .<\/p>\n<p>drwxr-xr-x\u00a0 3 oracle dba\u00a0 4096 May 24 13:30 ..<\/p>\n<p>drwxr-xr-x\u00a0 6 oracle dba\u00a0 4096 Sep 22\u00a0 2011 doc<\/p>\n<p>drwxr-xr-x\u00a0 4 oracle dba\u00a0 4096 Sep 22\u00a0 2011 install<\/p>\n<p>drwxr-xr-x\u00a0 4 oracle dba\u00a0 4096 Sep 22\u00a0 2011 legacy<\/p>\n<p>-rwxr-xr-x\u00a0 1 oracle dba 28122 Sep 22\u00a0 2011 readme.html<\/p>\n<p>drwxr-xr-x\u00a0 2 oracle dba\u00a0 4096 Sep 22\u00a0 2011 response<\/p>\n<p>-rwxr-xr-x\u00a0 1 oracle dba\u00a0 3226 Sep 22\u00a0 2011 runInstaller<\/p>\n<p>drwxr-xr-x 14 oracle dba\u00a0 4096 Sep 22\u00a0 2011 stage<\/p>\n<p>-rwxr-xr-x\u00a0 1 oracle dba\u00a0 6525 Aug 23\u00a0 2011 welcome.html<\/p>\n<p>[test1:\/oracle\/media\/gateways]$ .\/runInstaller<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><\/h2>\n<p>n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 GUI \ubaa8\ub4dc \uc124\uce58 \ud654\uba74<\/p>\n<p>&nbsp;<\/p>\n<p class=\"0\" style=\"line-height: normal; text-indent: 0cm; margin-top: 16px; margin-bottom: 16px; margin-left: 18pt; mso-list: none; tab-stops: 40.0pt;\"><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0054.gif\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image005[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0054_thumb.gif?resize=588%2C414\" alt=\"clip_image005[4]\" width=\"588\" height=\"414\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"0\" style=\"line-height: normal; text-indent: 0cm; margin-top: 16px; margin-bottom: 16px; margin-left: 18pt; mso-list: none; tab-stops: 40.0pt;\"><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0074.gif\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image007[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0074_thumb.gif?resize=588%2C430\" alt=\"clip_image007[4]\" width=\"588\" height=\"430\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"0\" style=\"line-height: normal; text-indent: 0cm; margin-top: 16px; margin-bottom: 16px; margin-left: 18pt; mso-list: none; tab-stops: 40.0pt;\"><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0094.gif\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image009[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0094_thumb.gif?resize=588%2C412\" alt=\"clip_image009[4]\" width=\"588\" height=\"412\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"0\" style=\"line-height: normal; text-indent: 0cm; margin-top: 16px; margin-bottom: 16px; margin-left: 18pt; mso-list: none; tab-stops: 40.0pt;\"><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0114.gif\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image011[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0114_thumb.gif?resize=588%2C426\" alt=\"clip_image011[4]\" width=\"588\" height=\"426\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"0\" style=\"line-height: normal; text-indent: 0cm; margin-top: 16px; margin-bottom: 16px; margin-left: 18pt; mso-list: none; tab-stops: 40.0pt;\"><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0134.gif\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image013[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0134_thumb.gif?resize=596%2C423\" alt=\"clip_image013[4]\" width=\"596\" height=\"423\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"0\" style=\"line-height: normal; text-indent: 0cm; margin-top: 16px; margin-bottom: 16px; margin-left: 18pt; mso-list: none; tab-stops: 40.0pt;\"><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0154.gif\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image015[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0154_thumb.gif?resize=596%2C431\" alt=\"clip_image015[4]\" width=\"596\" height=\"431\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"0\" style=\"line-height: normal; text-indent: 0cm; margin-top: 16px; margin-bottom: 16px; margin-left: 18pt; mso-list: none; tab-stops: 40.0pt;\"><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0174.gif\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image017[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0174_thumb.gif?resize=609%2C426\" alt=\"clip_image017[4]\" width=\"609\" height=\"426\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"0\" style=\"line-height: normal; text-indent: 0cm; margin-top: 16px; margin-bottom: 16px; margin-left: 18pt; mso-list: none; tab-stops: 40.0pt;\"><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0194.gif\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image019[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0194_thumb.gif?resize=608%2C433\" alt=\"clip_image019[4]\" width=\"608\" height=\"433\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"0\" style=\"line-height: normal; text-indent: 0cm; margin-top: 16px; margin-bottom: 16px; margin-left: 18pt; mso-list: none; tab-stops: 40.0pt;\"><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0214.gif\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image021[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0214_thumb.gif?resize=612%2C431\" alt=\"clip_image021[4]\" width=\"612\" height=\"431\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"0\" style=\"line-height: normal; text-indent: 0cm; margin-top: 16px; margin-bottom: 16px; margin-left: 18pt; mso-list: none; tab-stops: 40.0pt;\"><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0234.gif\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image023[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0234_thumb.gif?resize=612%2C419\" alt=\"clip_image023[4]\" width=\"612\" height=\"419\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"0\" style=\"line-height: normal; text-indent: 0cm; margin-top: 16px; margin-bottom: 16px; margin-left: 18pt; mso-list: none; tab-stops: 40.0pt;\"><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0254.gif\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image025[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0254_thumb.gif?resize=603%2C427\" alt=\"clip_image025[4]\" width=\"603\" height=\"427\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"0\" style=\"line-height: normal; text-indent: 0cm; margin-top: 16px; margin-bottom: 16px; margin-left: 18pt; mso-list: none; tab-stops: 40.0pt;\"><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0274.gif\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image027[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0274_thumb.gif?resize=603%2C420\" alt=\"clip_image027[4]\" width=\"603\" height=\"420\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<h1><a name=\"_Toc359000550\"><\/a>1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Gateway \uc124\uc815<\/h1>\n<h2><a name=\"_Toc359000551\"><\/a>1.1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DB2 Gateway \ud30c\ub77c\uba54\ud130 \uc124\uc815<\/h2>\n<ul>\n<li>$ORACLE_HOME\/dg4db2\/admin\/initdg4db2.ora \ud30c\uc77c \uc218\uc815<\/li>\n<li>Target DB Port Number : 50000<\/li>\n<li>Target DB Instance Name : sample<\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td width=\"614\">[test1:\/oracle\/product\/11g\/db\/dg4db2\/admin]$ cat initdg4db2.ora<\/p>\n<p># This is a customized agent init file that contains the HS parameters<\/p>\n<p># that are needed for the Database Gateway for DB2<\/p>\n<p># HS init parameters<\/p>\n<p>HS_FDS_CONNECT_INFO=[192.168.1.9]:50000\/sample,LUW<\/p>\n<p>HS_FDS_TRACE_LEVEL=OFF<\/p>\n<p>HS_FDS_RECOVERY_ACCOUNT=RECOVER<\/p>\n<p>HS_FDS_RECOVERY_PWD=RECOVER<\/p>\n<p>HS_TRANSACTION_MODEL=COMMIT_CONFIRM<\/p>\n<p>HS_FDS_TRANSACTION_ISOLATION=READ_COMMITTED<\/p>\n<p>HS_FDS_SUPPORT_STATISTICS=TRUE<\/p>\n<p>HS_FDS_RESULTSET_SUPPORT=FALSE<\/p>\n<p>HS_FDS_PACKAGE_COLLID=ORACLEGTW<\/p>\n<p>HS_IDLE_TIMEOUT=0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><\/h2>\n<h2><a name=\"_Toc359000552\"><\/a>1.2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SYBASE Gateway \ud30c\ub77c\uba54\ud130 \uc124\uc815<\/h2>\n<ul>\n<li>$ORACLE_HOME\/dg4sybs\/admin\/initdg4sybs.ora \ud30c\uc77c \uc218\uc815<\/li>\n<li>Target DB Port Number : 5000<\/li>\n<li>Target DB Instance Name : pubs2<\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td width=\"614\">[test1:\/oracle\/product\/11g\/db\/dg4sybs\/admin]$ cat initdg4sybs.ora<\/p>\n<p># This is a customized agent init file that contains the HS parameters<\/p>\n<p># that are needed for the Database Gateway for Sybase<\/p>\n<p># HS init parameters<\/p>\n<p>HS_FDS_CONNECT_INFO=[192.168.1.9]:5000\/pubs2<\/p>\n<p>HS_FDS_TRACE_LEVEL=OFF<\/p>\n<p>HS_FDS_RECOVERY_ACCOUNT=RECOVER<\/p>\n<p>HS_FDS_RECOVERY_PWD=RECOVER<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h1><a name=\"_Toc359000553\"><\/a>2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Oracle LISTENER \uc124\uc815<\/h1>\n<h2><a name=\"_Toc359000554\"><\/a>2.1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 listener.ora \ud30c\uc77c \uc124\uc815<\/h2>\n<ul>\n<li>$ORACLE_HOME\/network\/admin\/listener.ora<\/li>\n<\/ul>\n<table width=\"633\">\n<tbody>\n<tr>\n<td width=\"633\">[test1:\/oracle\/product\/11g\/db\/network\/admin]$ cat listener.ora<\/p>\n<p># listener.ora Network Configuration File: \/oracle\/product\/11g\/db\/network\/admin\/listener.ora<\/p>\n<p># Generated by Oracle configuration tools.<\/p>\n<p>LISTENER =\u00a0\u00a0\u00a0\u00a0 \u00df \uc624\ub77c\ud074 \uae30\ubcf8 \ub9ac\uc2a4\ub108<\/p>\n<p>(DESCRIPTION_LIST =<\/p>\n<p>(DESCRIPTION =<\/p>\n<p>(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.14)(PORT = 1521))<\/p>\n<p>(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))<\/p>\n<p>)<\/p>\n<p>)<\/p>\n<p>SID_LIST_LISTENER =<\/p>\n<p>(SID_LIST =<\/p>\n<p>(SID_DESC =<\/p>\n<p>(SID_NAME = test1)<\/p>\n<p>(ORACLE_HOME = \/oracle\/product\/11g\/db)<\/p>\n<p>)<\/p>\n<p>)<\/p>\n<p>&nbsp;<\/p>\n<p>LISTENER_GW =\u00a0\u00a0\u00a0\u00a0 \u00df DB2 Gateway \uc6a9 \ub9ac\uc2a4\ub108<\/p>\n<p>(DESCRIPTION =<\/p>\n<p>(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.14)(PORT = 1522))\u00a0\u00a0 \u00df Oracle Server IP<\/p>\n<p>)<\/p>\n<p>SID_LIST_LISTENER_GW =<\/p>\n<p>(SID_LIST =<\/p>\n<p>(SID_DESC =<\/p>\n<p>(SID_NAME = dg4db2)\u00a0\u00a0\u00a0\u00a0 \u00df tnsnames.ora \uc5d0 \uc124\uc815 \ub41c alias<\/p>\n<p>(ORACLE_HOME = \/oracle\/product\/11g\/db)<\/p>\n<p>(ENV=&#8221;LD_LIBRARY_PATH=\/oracle\/product\/11g\/db\/dg4db2\/driver\/lib;\/oracle\/product\/11g\/db\/lib&#8221;) (PROGRAM = dg4db2)<\/p>\n<p>)<\/p>\n<p>)<\/p>\n<p>&nbsp;<\/p>\n<p>LISTENER_SB =\u00a0\u00a0\u00a0 \u00a0\u00df Sybase Gateway \uc6a9 \ub9ac\uc2a4\ub108<\/p>\n<p>(DESCRIPTION =<\/p>\n<p>(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.14)(PORT = 1523))\u00a0\u00a0 \u00df Oracle Server IP<\/p>\n<p>)<\/p>\n<p>SID_LIST_LISTENER_SB =<\/p>\n<p>(SID_LIST =<\/p>\n<p>(SID_DESC =<\/p>\n<p>(SID_NAME = dg4sybs)\u00a0\u00a0\u00a0\u00a0 \u00df tnsnames.ora \uc5d0 \uc124\uc815 \ub41c alias<\/p>\n<p>(ORACLE_HOME = \/oracle\/product\/11g\/db)<\/p>\n<p>(ENV=LD_LIBRARY_PATH=\/oracle\/product\/11g\/db\/dg4sybs\/driver\/lib;\/oracle\/product\/11g\/db\/lib&#8221;)<\/p>\n<p>(PROGRAM = dg4sybs)<\/p>\n<p>)<\/p>\n<p>)<\/p>\n<p>&nbsp;<\/p>\n<p>ADR_BASE_LISTENER = \/oracle<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h2><a name=\"_Toc359000555\"><\/a>2.2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 tnsnames.ora \ud30c\uc77c \uc124\uc815<\/h2>\n<ul>\n<li>$ORACLE_HOME\/network\/admin\/tnsnames.ora<\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td width=\"630\">[test1:\/oracle\/product\/11g\/db\/network\/admin]$ cat tnsnames.ora<\/p>\n<p>TEST1 =\u00a0\u00a0 \u00df Oracle TNS \uba85<\/p>\n<p>(DESCRIPTION =<\/p>\n<p>(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.14)(PORT = 1521))<\/p>\n<p>(CONNECT_DATA =<\/p>\n<p>(SERVER = DEDICATED)<\/p>\n<p>(SERVICE_NAME = TEST1)<\/p>\n<p>)<\/p>\n<p>)<\/p>\n<p>&nbsp;<\/p>\n<p>dg4db2 =\u00a0\u00a0 \u00df DB2 TNS \uba85<\/p>\n<p>(description =<\/p>\n<p>(address = (protocol = tcp)(host = 192.168.1.14)(port = 1522))\u00a0\u00a0 \u00df Oracle Server IP<\/p>\n<p>(connect_data = (sid = dg4db2))<\/p>\n<p>(HS = OK)\u00a0\u00a0 \u00df \uc774\uae30\uc885 DB \uac04 \uc5f0\uacb0\uc744 \ud5c8\uc6a9<\/p>\n<p>)<\/p>\n<p>dg4sybs =\u00a0\u00a0\u00a0 \u00df Sybase TNS \uba85<\/p>\n<p>(description =<\/p>\n<p>(address = (protocol = tcp)(host = 192.168.1.14)(port = 1523))\u00a0\u00a0\u00a0 \u00df Oracle Server IP<\/p>\n<p>(connect_data = (sid = dg4sybs))<\/p>\n<p>(HS = OK)\u00a0\u00a0\u00a0 \u00df \uc774\uae30\uc885 DB \uac04 \uc5f0\uacb0\uc744 \ud5c8\uc6a9<\/p>\n<p>)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h2><a name=\"_Toc359000556\"><\/a>2.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LISTENER \uc2dc\uc791<\/h2>\n<ul>\n<li>DB2 Gateway \uc6a9 \ub9ac\uc2a4\ub108 \uae30\ub3d9<\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td width=\"623\">[test1:\/oracle]$ lsnrctl start LISTENER_GW<\/p>\n<p>&nbsp;<\/p>\n<p>LSNRCTL for Linux: Version 11.2.0.3.0 &#8211; Production on 14-JUN-2013 16:59:21<\/p>\n<p>Copyright (c) 1991, 2011, Oracle.\u00a0 All rights reserved.<\/p>\n<p>Starting \/oracle\/product\/11g\/db\/bin\/tnslsnr: please wait&#8230;<\/p>\n<p>&nbsp;<\/p>\n<p>(\uc911\ub7b5)<\/p>\n<p>&nbsp;<\/p>\n<p>Service &#8220;dg4db2&#8221; has 1 instance(s).<\/p>\n<p>Instance &#8220;dg4db2&#8221;, status UNKNOWN, has 1 handler(s) for this service&#8230;<\/p>\n<p>The command completed successfully<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<ul>\n<li>SYBASE Gateway \uc6a9 \ub9ac\uc2a4\ub108 \uae30\ub3d9<\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td width=\"624\">[test1:\/oracle]$ lsnrctl start LISTENER_SB<\/p>\n<p>&nbsp;<\/p>\n<p>LSNRCTL for Linux: Version 11.2.0.3.0 &#8211; Production on 14-JUN-2013 17:02:31<\/p>\n<p>Copyright (c) 1991, 2011, Oracle.\u00a0 All rights reserved.<\/p>\n<p>Starting \/oracle\/product\/11g\/db\/bin\/tnslsnr: please wait&#8230;<\/p>\n<p>&nbsp;<\/p>\n<p>(\uc911\ub7b5)<\/p>\n<p>&nbsp;<\/p>\n<p>Service &#8220;dg4sybs&#8221; has 1 instance(s).<\/p>\n<p>Instance &#8220;dg4sybs&#8221;, status UNKNOWN, has 1 handler(s) for this service&#8230;<\/p>\n<p>The command completed successfully<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h1><a name=\"_Toc359000557\"><\/a>3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DB Link \uc0dd\uc131<\/h1>\n<ul>\n<li>Gateway \uc81c\ud488 \uc124\uce58 \ubc0f \uc774\uae30\uc885 DB \uc5f0\ub3d9\uc744 \uc704\ud55c \ubaa8\ub4e0 \uc124\uc815\uc774 \uc644\ub8cc \ub418\uc5c8\ub2e4<\/li>\n<li>\uc774\uc81c \uc624\ub77c\ud074\uc5d0\uc11c DB Link \ub97c \ub9cc\ub4e4\uc5b4 \uae30\uc874 Oracle &#8211; Oracle \uacfc \ub611\uac19\uc740 \ubc29\uc2dd\uc73c\ub85c \ub9c1\ud06c<\/li>\n<\/ul>\n<p>\uc5f0\uacb0\ud558\uc5ec \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4.<\/p>\n<ul>\n<li>DB Link \uc0dd\uc131 SQL<\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td width=\"586\">SQL&gt; create public database link <strong>\ub9c1\ud06c\uba85<\/strong> connect to <strong>\uc720\uc800\uba85<\/strong> identified by <strong>\ud328\uc2a4\uc6cc\ub4dc<\/strong><\/p>\n<p>using <strong>&#8216;TNSNAMES.ORA<\/strong><strong>\uc5d0\uc11c <\/strong><strong>\uc9c0\uc815\ud55c <\/strong><strong>\uc11c\ube44\uc2a4\uba85<\/strong>&#8216;;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h2><a name=\"_Toc359000558\"><\/a>3.1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DB2 \uc5f0\uacb0\uc744 \uc704\ud55c DB Link \uc0dd\uc131<\/h2>\n<ul>\n<li>DB2 \uc811\uc18d User Name : db2inst1<\/li>\n<li>DB2 \uc720\uc800 \ud328\uc2a4\uc6cc\ub4dc : db2inst1<\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td width=\"620\">SQL&gt; create public database link DB2_LINK connect to db2inst1 identified by db2inst1 using &#8216;dg4db2&#8217;;<\/p>\n<p>Database link created.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h2><a name=\"_Toc359000559\"><\/a>3.2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SYBASE \uc5f0\uacb0\uc744 \uc704\ud55c DB Link \uc0dd\uc131<\/h2>\n<ul>\n<li>DB2 \uc811\uc18d User Name : sa<\/li>\n<li>DB2 \uc720\uc800 \ud328\uc2a4\uc6cc\ub4dc : sybase<\/li>\n<li>SYBASE\ub294 \ub300\/\uc18c\ubb38\uc790\ub97c \uc5c4\uaca9\ud558\uac8c \uad6c\ubcc4\ud55c\ub2e4. \ubc18\ub4dc\uc2dc \u201c-\u201c \ub530\uc634\ud45c\ub85c \ubb36\uc5b4\uc8fc\uc5b4\uc57c \ud55c\ub2e4<\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td width=\"620\">SQL&gt; create public database link sb_link connect to &#8220;sa&#8221; identified by &#8220;sybase&#8221; using &#8216;dg4sybs&#8217;;<\/p>\n<p>Database link created.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h2><a name=\"_Toc359000560\"><\/a>3.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DB Link \uc0dd\uc131 \ud655\uc778<\/h2>\n<table>\n<tbody>\n<tr>\n<td width=\"620\">SQL&gt; select * from dba_db_links;<\/p>\n<p>&nbsp;<\/p>\n<p>OWNER \u00a0\u00a0 DB_LINK\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 USERNAME\u00a0\u00a0\u00a0\u00a0 HOST\u00a0\u00a0\u00a0 \u00a0 CREATED<\/p>\n<p>&#8212;&#8212;&#8212;- \u00a0\u00a0\u00a0&#8212;&#8212;&#8212;&#8212;\u00a0\u00a0\u00a0 \u00a0&#8212;&#8212;&#8212;&#8212; \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8212;&#8212;&#8212;&#8212; \u00a0&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<\/p>\n<p>PUBLIC\u00a0 \u00a0\u00a0 DB2_LINK\u00a0\u00a0\u00a0\u00a0\u00a0 DB2INST1\u00a0\u00a0\u00a0 \u00a0\u00a0dg4db2\u00a0\u00a0 \u00a0 2013-05-24:13:48:31<\/p>\n<p>PUBLIC\u00a0 \u00a0\u00a0 SB_LINK\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sa\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0dg4sybs \u00a0 2013-05-24:13:58:24<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h1><a name=\"_Toc359000561\"><\/a>4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Gateway \ub370\uc774\ud130 \uc870\ud68c (select)<\/h1>\n<h2><a name=\"_Toc359000562\"><\/a>4.1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Oracle \u2013 DB2 \ub370\uc774\ud130 \uc870\ud68c<\/h2>\n<ul>\n<li>DB2 Databae \uc5d0\uc11c \u2018staff\u2019 \ud14c\uc774\ube14 \uc870\ud68c(Instance Name : sample)<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 20pt; line-height: normal; -ms-text-justify: inter-ideograph;\" align=\"justify\"><span style=\"left: 0px; width: 144px; height: 4px; margin-top: 138px; margin-left: 73px; position: absolute; z-index: 3; mso-ignore: vglayout;\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0284.gif\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image028[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0284_thumb.gif?resize=144%2C4\" alt=\"clip_image028[4]\" width=\"144\" height=\"4\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0304.jpg\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image030[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0304_thumb.jpg?resize=511%2C329\" alt=\"clip_image030[4]\" width=\"511\" height=\"329\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 20pt; line-height: normal; -ms-text-justify: inter-ideograph;\" align=\"justify\"><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0324.jpg\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image032[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0324_thumb.jpg?resize=511%2C406\" alt=\"clip_image032[4]\" width=\"511\" height=\"406\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 40pt; line-height: normal; text-indent: -20pt; -ms-text-justify: inter-ideograph; mso-list: l5 level1 lfo8;\" align=\"justify\"><span lang=\"EN-US\" style=\"mso-bidi-font-family: wingdings; mso-fareast-font-family: wingdings;\"><span style=\"mso-list: ignore;\"><span style=\"font-size: 10pt;\">n<\/span><span style=\"line-height: normal; font-size-adjust: none; font-stretch: normal;\"><span style=\"font-size: 7pt;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span><span lang=\"EN-US\"><span style=\"font-size: 10pt;\">Oracle Databae <\/span><\/span><span style=\"font-size: 10pt;\"><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc5d0\uc11c<\/span><span lang=\"EN-US\"> dblink <\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ub97c\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ud1b5\ud574<\/span><span lang=\"EN-US\">\u2018staff\u2019 <\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ud14c\uc774\ube14\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc870\ud68c\u00a0<\/span><span lang=\"EN-US\">\u2013 <\/span><\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\"><span style=\"font-size: 10pt;\">\uc131\uacf5<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 20pt; line-height: normal; -ms-text-justify: inter-ideograph;\" align=\"justify\"><span style=\"left: 0px; width: 213px; height: 4px; margin-top: 18px; margin-left: 61px; position: absolute; z-index: 4; mso-ignore: vglayout;\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0334.gif\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image033[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0334_thumb.gif?resize=213%2C4\" alt=\"clip_image033[4]\" width=\"213\" height=\"4\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0354.jpg\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image035[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0354_thumb.jpg?resize=612%2C308\" alt=\"clip_image035[4]\" width=\"612\" height=\"308\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 20pt; line-height: normal; -ms-text-justify: inter-ideograph;\" align=\"justify\"><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0374.jpg\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image037[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0374_thumb.jpg?resize=612%2C335\" alt=\"clip_image037[4]\" width=\"612\" height=\"335\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"margin: 0cm 0cm 0pt 36pt; line-height: normal; text-indent: -36pt; padding-bottom: 0px; -ms-text-justify: inter-ideograph;\" align=\"justify\"><a name=\"_Toc359000563\"><\/a><span lang=\"EN-US\" style=\"mso-fareast-font-family: arial;\"><span style=\"mso-list: ignore;\"><span style=\"font-size: 14pt;\">9.2<\/span><span style=\"line-height: normal; font-size-adjust: none; font-stretch: normal;\"><span style=\"font-size: 7pt;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span><span lang=\"EN-US\"><span style=\"font-size: 14pt;\">Oracle \u2013 Sybase <\/span><\/span><span style=\"font-size: 14pt;\"><span style=\"mso-bookmark: _toc359000563;\"><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ub370\uc774\ud130\u00a0<\/span><\/span><\/span><span style=\"mso-bookmark: _toc359000563;\"><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\"><span style=\"font-size: 14pt;\">\uc870\ud68c<\/span><\/span><\/span><\/h2>\n<p>&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 40pt; line-height: normal; text-indent: -20pt; -ms-text-justify: inter-ideograph; mso-list: l5 level1 lfo8;\" align=\"justify\"><span lang=\"EN-US\" style=\"mso-bidi-font-family: wingdings; mso-fareast-font-family: wingdings;\"><span style=\"mso-list: ignore;\"><span style=\"font-size: 10pt;\">n<\/span><span style=\"line-height: normal; font-size-adjust: none; font-stretch: normal;\"><span style=\"font-size: 7pt;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span><span style=\"left: 0px; width: 36px; height: 438px; margin-top: 22px; margin-left: 611px; position: absolute; z-index: 5; mso-ignore: vglayout;\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0384.gif\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image038[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0384_thumb.gif?resize=36%2C438\" alt=\"clip_image038[4]\" width=\"36\" height=\"438\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><span lang=\"EN-US\"><span style=\"font-size: 10pt;\">Sybase Databae <\/span><\/span><span style=\"font-size: 10pt;\"><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc5d0\uc11c\u00a0<\/span><span lang=\"EN-US\">\u2018sales\u2019 <\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ud14c\uc774\ube14\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc870\ud68c<\/span><\/span><span lang=\"EN-US\"><span style=\"font-size: 10pt;\">(Instance Name : pubs2)<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 20pt; line-height: normal; -ms-text-justify: inter-ideograph;\" align=\"justify\"><span style=\"left: 0px; width: 152px; height: 3px; margin-top: 63px; margin-left: 50px; position: absolute; z-index: 6; mso-ignore: vglayout;\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0394.gif\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image039[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0394_thumb.gif?resize=152%2C3\" alt=\"clip_image039[4]\" width=\"152\" height=\"3\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0414.jpg\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image041[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0414_thumb.jpg?resize=618%2C427\" alt=\"clip_image041[4]\" width=\"618\" height=\"427\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 20pt; line-height: normal; -ms-text-justify: inter-ideograph;\" align=\"justify\"><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0434.jpg\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image043[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0434_thumb.jpg?resize=587%2C191\" alt=\"clip_image043[4]\" width=\"587\" height=\"191\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 20pt; line-height: normal; -ms-text-justify: inter-ideograph;\" align=\"justify\"><span lang=\"EN-US\"><span style=\"font-size: 10pt;\">\u00a0<\/span><\/span><\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 40pt; line-height: normal; text-indent: -20pt; -ms-text-justify: inter-ideograph; mso-list: l5 level1 lfo8;\" align=\"justify\"><span lang=\"EN-US\" style=\"mso-bidi-font-family: wingdings; mso-fareast-font-family: wingdings;\"><span style=\"mso-list: ignore;\"><span style=\"font-size: 10pt;\">n<\/span><span style=\"line-height: normal; font-size-adjust: none; font-stretch: normal;\"><span style=\"font-size: 7pt;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span><span lang=\"EN-US\"><span style=\"font-size: 10pt;\">Oracle Databae <\/span><\/span><span style=\"font-size: 10pt;\"><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc5d0\uc11c<\/span><span lang=\"EN-US\"> dblink <\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ub97c\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ud1b5\ud574\u00a0<\/span><span lang=\"EN-US\">\u2018sales\u2019 <\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ud14c\uc774\ube14\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc870\ud68c\u00a0<\/span><span lang=\"EN-US\">\u2013 <\/span><\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\"><span style=\"font-size: 10pt;\">\uc2e4\ud328<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 20pt; line-height: normal; -ms-text-justify: inter-ideograph;\" align=\"justify\"><span style=\"left: 0px; width: 207px; height: 4px; margin-top: 20px; margin-left: 59px; position: absolute; z-index: 7; mso-ignore: vglayout;\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0444.gif\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image044[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0444_thumb.gif?resize=207%2C4\" alt=\"clip_image044[4]\" width=\"207\" height=\"4\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0464.jpg\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image046[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0464_thumb.jpg?resize=594%2C130\" alt=\"clip_image046[4]\" width=\"594\" height=\"130\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 40pt; line-height: normal; text-indent: -20pt; -ms-text-justify: inter-ideograph; mso-list: l5 level1 lfo8;\" align=\"justify\"><span lang=\"EN-US\" style=\"mso-bidi-font-family: wingdings; mso-fareast-font-family: wingdings;\"><span style=\"mso-list: ignore;\"><span style=\"font-size: 10pt;\">n<\/span><span style=\"line-height: normal; font-size-adjust: none; font-stretch: normal;\"><span style=\"font-size: 7pt;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\"><span style=\"font-size: 10pt;\">\uc911\uc694<\/span><\/span><span style=\"font-size: 10pt;\"><span lang=\"EN-US\">) <\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc704\uc5d0\uc11c\ub3c4\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc5b8\uae09\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ud588\ub4ef\uc774<\/span><span lang=\"EN-US\"> Sybase <\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc5d0\uc11c\ub294\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ub300<\/span><span lang=\"EN-US\">\/<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc18c\ubb38\uc790\ub97c\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc5c4\uaca9\ud558\uac8c\u00a0<\/span><\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\"><span style=\"font-size: 10pt;\">\uad6c\ubcc4\ud55c\ub2e4<\/span><\/span><\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 40pt; line-height: normal; -ms-text-justify: inter-ideograph;\" align=\"justify\"><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\"><span style=\"font-size: 10pt;\">\ub530\ub77c\uc11c<\/span><\/span><span style=\"font-size: 10pt;\"> <span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ud14c\uc774\ube14\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uba85\uc744\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ube44\ub86f\ud55c\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ubaa8\ub4e0\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ud544\ub4dc\uba85\uc5d0\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ubc18\ub4dc\uc2dc\u00a0<\/span><span lang=\"EN-US\">\u201c-\u201c <\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ub530\uc634\ud45c\ub97c\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ubd99\uc5ec\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uad6c\ubcc4\ud574\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc8fc\uc5b4\uc57c\u00a0<\/span><\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\"><span style=\"font-size: 10pt;\">\ud55c\ub2e4<\/span><\/span><\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 40pt; line-height: normal; text-indent: -20pt; -ms-text-justify: inter-ideograph; mso-list: l5 level1 lfo8;\" align=\"justify\"><span lang=\"EN-US\" style=\"mso-bidi-font-family: wingdings; mso-fareast-font-family: wingdings;\"><span style=\"mso-list: ignore;\"><span style=\"font-size: 10pt;\">n<\/span><span style=\"line-height: normal; font-size-adjust: none; font-stretch: normal;\"><span style=\"font-size: 7pt;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span><span lang=\"EN-US\"><span style=\"font-size: 10pt;\">Oracle Databae <\/span><\/span><span style=\"font-size: 10pt;\"><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc5d0\uc11c<\/span><span lang=\"EN-US\"> dblink <\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ub97c\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ud1b5\ud574\u00a0<\/span><span lang=\"EN-US\">\u201csales\u201d <\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ud14c\uc774\ube14\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc870\ud68c\u00a0<\/span><span lang=\"EN-US\">\u2013 <\/span><\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\"><span style=\"font-size: 10pt;\">\uc131\uacf5<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 20pt; line-height: normal; -ms-text-justify: inter-ideograph;\" align=\"justify\"><span style=\"left: 0px; width: 213px; height: 4px; margin-top: 23px; margin-left: 64px; position: absolute; z-index: 8; mso-ignore: vglayout;\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0474.gif\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image047[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0474_thumb.gif?resize=213%2C4\" alt=\"clip_image047[4]\" width=\"213\" height=\"4\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0494.jpg\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image049[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0494_thumb.jpg?resize=594%2C518\" alt=\"clip_image049[4]\" width=\"594\" height=\"518\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 20pt; line-height: normal; -ms-text-justify: inter-ideograph;\" align=\"justify\"><span lang=\"EN-US\"><span style=\"font-size: 10pt;\">\u00a0<\/span><\/span><\/p>\n<h1 style=\"margin: 0cm 0cm 0pt 27.75pt; line-height: normal; text-indent: -27.75pt; padding-bottom: 0px; -ms-text-justify: inter-ideograph;\" align=\"justify\"><a name=\"_Toc359000564\"><\/a><span lang=\"EN-US\" style=\"mso-fareast-font-family: arial;\"><span style=\"mso-list: ignore;\"><span style=\"font-size: 16pt;\">10<\/span><span style=\"line-height: normal; font-size-adjust: none; font-stretch: normal;\"><span style=\"font-size: 7pt;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span><span lang=\"EN-US\"><span style=\"font-size: 16pt;\">Gateway <\/span><\/span><span style=\"font-size: 16pt;\"><span style=\"mso-bookmark: _toc359000564;\"><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ub370\uc774\ud130\u00a0<\/span><\/span><\/span><span style=\"mso-bookmark: _toc359000564;\"><span style=\"font-size: 16pt;\"><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc774\ud589\u00a0<\/span><\/span><span lang=\"EN-US\"><span style=\"font-size: 16pt;\">(migration)<\/span><\/span><\/span><\/h1>\n<p>&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 40pt; line-height: normal; text-indent: -20pt; -ms-text-justify: inter-ideograph; mso-list: l5 level1 lfo8;\" align=\"justify\"><span lang=\"EN-US\" style=\"mso-bidi-font-family: wingdings; mso-fareast-font-family: wingdings;\"><span style=\"mso-list: ignore;\"><span style=\"font-size: 10pt;\">n<\/span><span style=\"line-height: normal; font-size-adjust: none; font-stretch: normal;\"><span style=\"font-size: 7pt;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span><span lang=\"EN-US\"><span style=\"font-size: 10pt;\">create table ~ as ~ select <\/span><\/span><span style=\"font-size: 10pt;\"><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uba85\ub839\ubb38\uc744\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc0ac\uc6a9\ud558\uc5ec\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ud14c\uc774\ube14\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ubc0f\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ub370\uc774\ud130\ub97c\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uac00\uc838\uc62c\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc218\u00a0<\/span><\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\"><span style=\"font-size: 10pt;\">\uc788\ub2e4<\/span><\/span><\/p>\n<table class=\"MsoNormalTable\" style=\"border: currentcolor; width: auto; line-height: normal; margin-left: 20pt; border-collapse: collapse; mso-border-alt: solid windowtext .5pt; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-border-insideh: .5pt solid windowtext; mso-border-insidev: .5pt solid windowtext;\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody style=\"vertical-align: middle;\">\n<tr style=\"vertical-align: middle; mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes;\">\n<td style=\"padding: 0cm 5.4pt; border: 1pt solid windowtext; vertical-align: middle; mso-border-alt: solid windowtext .5pt;\" valign=\"top\" width=\"594\">&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt; line-height: normal; text-indent: 20pt; -ms-text-justify: inter-ideograph; mso-char-indent-count: 2.0;\" align=\"justify\"><span lang=\"EN-US\"><span style=\"font-size: 10pt;\">SQL&gt; create table <b style=\"mso-bidi-font-weight: normal;\"><i style=\"mso-bidi-font-style: normal;\">table_name<\/i><\/b> as (select * from <b style=\"mso-bidi-font-weight: normal;\"><i style=\"mso-bidi-font-style: normal;\">target_table_name@db_link<\/i><\/b>);<\/span><\/span><\/p>\n<p>&nbsp;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt; line-height: normal; -ms-text-justify: inter-ideograph;\" align=\"justify\"><span lang=\"EN-US\"><span style=\"font-size: 10pt;\">\u00a0<\/span><\/span><\/p>\n<h2 style=\"margin: 0cm 0cm 0pt 36pt; line-height: normal; text-indent: -36pt; padding-bottom: 0px; -ms-text-justify: inter-ideograph;\" align=\"justify\"><a name=\"_Toc359000565\"><\/a><span lang=\"EN-US\" style=\"mso-fareast-font-family: arial;\"><span style=\"mso-list: ignore;\"><span style=\"font-size: 14pt;\">10.1<\/span><span style=\"line-height: normal; font-size-adjust: none; font-stretch: normal;\"><span style=\"font-size: 7pt;\">\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span><span lang=\"EN-US\"><span style=\"font-size: 14pt;\">Oracle \u2013 DB2 <\/span><\/span><span style=\"font-size: 14pt;\"><span style=\"mso-bookmark: _toc359000565;\"><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ub370\uc774\ud130\u00a0<\/span><\/span><span style=\"mso-bookmark: _toc359000565;\"><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc774\ud589<\/span><\/span><br \/>\n<\/span><\/h2>\n<p>&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 40pt; line-height: normal; text-indent: -20pt; -ms-text-justify: inter-ideograph; mso-list: l5 level1 lfo8;\" align=\"justify\"><span lang=\"EN-US\" style=\"mso-bidi-font-family: wingdings; mso-fareast-font-family: wingdings;\"><span style=\"mso-list: ignore;\"><span style=\"font-size: 10pt;\">n<\/span><span style=\"line-height: normal; font-size-adjust: none; font-stretch: normal;\"><span style=\"font-size: 7pt;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span><span lang=\"EN-US\"><span style=\"font-size: 10pt;\">Oracle Databae <\/span><\/span><span style=\"font-size: 10pt;\"><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc5d0\uc11c<\/span><span lang=\"EN-US\"> dblink <\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ub97c\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ud1b5\ud574\u00a0<\/span><span lang=\"EN-US\">DB2 <\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc758\u00a0<\/span><span lang=\"EN-US\">\u2018staff\u2019 <\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ud14c\uc774\ube14\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc0dd\uc131\u00a0<\/span><span lang=\"EN-US\">\u2013 <\/span><\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\"><span style=\"font-size: 10pt;\">\uc131\uacf5<\/span><\/span><\/p>\n<table class=\"MsoNormalTable\" style=\"border: currentcolor; width: auto; line-height: normal; margin-left: 20pt; border-collapse: collapse; mso-border-alt: solid windowtext .5pt; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-border-insideh: .5pt solid windowtext; mso-border-insidev: .5pt solid windowtext;\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody style=\"vertical-align: middle;\">\n<tr style=\"vertical-align: middle; mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes;\">\n<td style=\"padding: 0cm 5.4pt; border: 1pt solid windowtext; vertical-align: middle; mso-border-alt: solid windowtext .5pt;\" valign=\"top\" width=\"594\">\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 20pt; line-height: normal; -ms-text-justify: inter-ideograph;\" align=\"justify\"><span lang=\"EN-US\"><span style=\"font-size: 10pt;\">SQL&gt; create table staff as<br \/>\n(select * from staff@DB2_LINK);<\/span><\/span><\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt; line-height: normal; text-indent: 20pt; -ms-text-justify: inter-ideograph; mso-char-indent-count: 2.0;\" align=\"justify\"><span lang=\"EN-US\"><span style=\"font-size: 10pt;\">Table created.<\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 40pt; line-height: normal; text-indent: -20pt; -ms-text-justify: inter-ideograph; mso-list: l5 level1 lfo8;\" align=\"justify\"><span lang=\"EN-US\" style=\"mso-bidi-font-family: wingdings; mso-fareast-font-family: wingdings;\"><span style=\"mso-list: ignore;\"><span style=\"font-size: 10pt;\">n<\/span><span style=\"line-height: normal; font-size-adjust: none; font-stretch: normal;\"><span style=\"font-size: 7pt;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span><span lang=\"EN-US\"><span style=\"font-size: 10pt;\">Oracle <\/span><\/span><span style=\"font-size: 10pt;\"><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc5d0\uc11c\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc0dd\uc131\ub41c\u00a0<\/span><span lang=\"EN-US\">\u2018staff\u2019 <\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ud14c\uc774\ube14\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc870\ud68c\u00a0<\/span><\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\"><span style=\"font-size: 10pt;\">\ud655\uc778<\/span><\/span><\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 20pt; line-height: normal; -ms-text-justify: inter-ideograph;\" align=\"justify\"><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0514.jpg\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image051[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0514_thumb.jpg?resize=492%2C326\" alt=\"clip_image051[4]\" width=\"492\" height=\"326\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 20pt; line-height: normal; -ms-text-justify: inter-ideograph;\" align=\"justify\"><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0534.jpg\"><img loading=\"lazy\" style=\"margin: 0px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image053[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0534_thumb.jpg?resize=493%2C235\" alt=\"clip_image053[4]\" width=\"493\" height=\"235\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"margin: 0cm 0cm 0pt 36pt; line-height: normal; text-indent: -36pt; padding-bottom: 0px; -ms-text-justify: inter-ideograph;\" align=\"justify\"><a name=\"_Toc359000566\"><\/a><span lang=\"EN-US\" style=\"mso-fareast-font-family: arial;\"><span style=\"mso-list: ignore;\"><span style=\"font-size: 14pt;\">10.2<\/span><span style=\"line-height: normal; font-size-adjust: none; font-stretch: normal;\"><span style=\"font-size: 7pt;\">\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span><span lang=\"EN-US\"><span style=\"font-size: 14pt;\">Oracle \u2013 Sybase <\/span><\/span><span style=\"font-size: 14pt;\"><span style=\"mso-bookmark: _toc359000566;\"><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ub370\uc774\ud130\u00a0<\/span><\/span><\/span><span style=\"mso-bookmark: _toc359000566;\"><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\"><span style=\"font-size: 14pt;\">\uc774\ud589<\/span><\/span><\/span><\/h2>\n<p>&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 40pt; line-height: normal; text-indent: -20pt; -ms-text-justify: inter-ideograph; mso-list: l5 level1 lfo8;\" align=\"justify\"><span lang=\"EN-US\" style=\"mso-bidi-font-family: wingdings; mso-fareast-font-family: wingdings;\"><span style=\"mso-list: ignore;\"><span style=\"font-size: 10pt;\">n<\/span><span style=\"line-height: normal; font-size-adjust: none; font-stretch: normal;\"><span style=\"font-size: 7pt;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span><span lang=\"EN-US\"><span style=\"mso-spacerun: yes;\"><span style=\"font-size: 10pt;\">\u00a0<\/span><\/span><span style=\"font-size: 10pt;\">Oracle Databae <\/span><\/span><span style=\"font-size: 10pt;\"><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc5d0\uc11c<\/span><span lang=\"EN-US\"> dblink <\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ub97c\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ud1b5\ud574<\/span><span lang=\"EN-US\"> Sybase <\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc758\u00a0<\/span><span lang=\"EN-US\">\u2018sales\u2019 <\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ud14c\uc774\ube14\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc0dd\uc131\u00a0<\/span><span lang=\"EN-US\">\u2013 <\/span><\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\"><span style=\"font-size: 10pt;\">\uc131\uacf5<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<table class=\"MsoNormalTable\" style=\"border: currentcolor; width: auto; line-height: normal; margin-left: 20pt; border-collapse: collapse; mso-border-alt: solid windowtext .5pt; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-border-insideh: .5pt solid windowtext; mso-border-insidev: .5pt solid windowtext;\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody style=\"vertical-align: middle;\">\n<tr style=\"vertical-align: middle; mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes;\">\n<td style=\"padding: 0cm 5.4pt; border: 1pt solid windowtext; vertical-align: middle; mso-border-alt: solid windowtext .5pt;\" valign=\"top\" width=\"604\">&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 20pt; line-height: normal; -ms-text-justify: inter-ideograph;\" align=\"justify\"><span lang=\"EN-US\"><span style=\"font-size: 10pt;\">SQL&gt; create table sales as<br \/>\n(select * from &#8220;sales&#8221;@SB_LINK);<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 20pt; line-height: normal; -ms-text-justify: inter-ideograph;\" align=\"justify\"><span lang=\"EN-US\"><span style=\"font-size: 10pt;\">Table created.<\/span><\/span><\/p>\n<p>&nbsp;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 style=\"margin: 0cm 0cm 0pt; line-height: normal; text-indent: 0cm; padding-bottom: 0px; -ms-text-justify: inter-ideograph; mso-list: none; tab-stops: 40.0pt;\" align=\"justify\"><span lang=\"EN-US\"><span style=\"font-size: 14pt;\">\u00a0<\/span><\/span><\/h2>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 40pt; line-height: normal; text-indent: -20pt; -ms-text-justify: inter-ideograph; mso-list: l5 level1 lfo8;\" align=\"justify\"><span lang=\"EN-US\" style=\"mso-bidi-font-family: wingdings; mso-fareast-font-family: wingdings;\"><span style=\"mso-list: ignore;\"><span style=\"font-size: 10pt;\">n<\/span><span style=\"line-height: normal; font-size-adjust: none; font-stretch: normal;\"><span style=\"font-size: 7pt;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span><\/span><span lang=\"EN-US\"><span style=\"font-size: 10pt;\">Oracle <\/span><\/span><span style=\"font-size: 10pt;\"><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc5d0\uc11c\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc0dd\uc131\ub41c\u00a0<\/span><span lang=\"EN-US\">\u2018sales\u2019 <\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\ud14c\uc774\ube14\u00a0<\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\">\uc870\ud68c\u00a0<\/span><\/span><span style=\"mso-ascii-font-family: arial; mso-hansi-font-family: arial;\"><span style=\"font-size: 10pt;\">\ud655\uc778<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<p class=\"a\" style=\"margin: 0cm 0cm 0pt 20pt; line-height: normal; -ms-text-justify: inter-ideograph;\" align=\"justify\"><span lang=\"EN-US\"><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0554.jpg\"><img loading=\"lazy\" style=\"margin: 0px 0px 18px; border: 0px currentcolor; display: inline; max-width: none; background-image: none;\" title=\"clip_image055[4]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2019\/01\/clip_image0554_thumb.jpg?resize=516%2C522\" alt=\"clip_image055[4]\" width=\"516\" height=\"522\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Gateway \uac1c\uc694 n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \uc774\uae30\uc885 Database \uac04\uc758 \ud1b5\uc2e0\uc744 \uc704\ud574\uc11c \uc624\ub77c\ud074\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \uc81c\ud488\uc774\ub2e4. n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \uc774\uae30\uc885 \uc2dc\uc2a4\ud15c \uac04\uc758 SQL \ubcc0\ud658, \ub370\uc774\ud130\uc758 \uc6d0\ud65c\ud55c \uc0c1\ud638 \uc6b4\uc601\uc131\uc744 \uc81c\uacf5\ud55c\ub2e4 n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Oracle 9i \ubc84\uc804\ubd80\ud130 CD\uc5d0 \ud3ec\ud568\ub418\uc5b4 \uc81c\uacf5\ub418\uace0 \uc788\uc73c\uba70 Gateway \uc11c\ube44\uc2a4\ub97c \uc81c\uacf5 \ubc1b\uc73c\ub824\uba74 \ubcc4\ub3c4\uc758 \ub77c\uc774\uc120\uc2a4\ub97c \uad6c\ub9e4\ud574\uc57c \ud55c\ub2e4 &nbsp; 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Gateway \uc6d0\ub9ac \uc774\uae30\uc885\uac04 \uc11c\ube44\uc2a4(Heterogeneous Connectivity)\uc5d0 \uc758\ud574 Oracle SQL \uc744 Oracle \uc774\uc678\uc758 \uc2dc\uc2a4\ud15c\uc758 \uc801\uc808\ud55c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4314,"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":[9],"tags":[1131,1130,1132,1133],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2019\/01\/oracle-api-gateway-overview-1-638.jpg?fit=638%2C359","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4246"}],"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=4246"}],"version-history":[{"count":5,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4246\/revisions"}],"predecessor-version":[{"id":4315,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4246\/revisions\/4315"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/4314"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4246"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4246"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}