{"id":4665,"date":"2021-11-04T14:35:03","date_gmt":"2021-11-04T05:35:03","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=4665"},"modified":"2021-11-04T14:38:03","modified_gmt":"2021-11-04T05:38:03","slug":"max_string_size-%ea%b8%b0%eb%8a%a5-%ed%99%9c%ec%9a%a9-oracle-12c","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=4665","title":{"rendered":"MAX_STRING_SIZE \uae30\ub2a5 \ud65c\uc6a9 ( Oracle 12c ~ )"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>MAX_STRING_SIZE = EXTENDED<\/p>\n<p>\uc124\uc815\uc744 \ud558\uac8c \ub418\uba74 varchar2(4000) \uc5d0\uc11c varchar2(32767) \uae4c\uc9c0 \uc0ac\uc6a9\uc774 \uac00\ub2a5 \ud569\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>\uc624\ub77c\ud074 \ubb38\uc11c<\/p>\n<p><a href=\"https:\/\/docs.oracle.com\/database\/121\/REFRN\/GUID-D424D23B-0933-425F-BC69-9C0E6724693C.htm?fbclid=IwAR0bwaa-MPY7RBkyHyfz35s2f3lbnDemm_1_skof64vwccOK4edJ24zEaus#REFRN10321\">https:\/\/docs.oracle.com\/&#8230;\/GUID-D424D23B-0933-425F-BC69&#8230;<\/a><\/p>\n<p>\uc7a5\uc810\uc740 \ubb34\uc5c7\uc774\uba70 \ub2e8\uc810\uc744 \ubb34\uc5c7\uc774 \uc788\uc744\uae4c\uc694?<\/p>\n<p>&nbsp;<\/p>\n<p><strong>1. \uc7a5\uc810<\/strong><\/p>\n<p>: \uc9c0\uae08\uc740 \uac70\uc758 LONG \ud0c0\uc785\uc774 \uc5c6\uaca0\uc9c0\ub9cc \ub300\uccb4 \uac00\ub2a5 \ud569\ub2c8\ub2e4.<\/p>\n<p>: LOB \ud0c0\uc785\uae4c\uc9c0 \uc0ac\uc6a9 \ud560 \ud544\uc694\uc131\uc774 \uc5c6\ub2e4\uace0 \ud310\ub2e8\uc774 \ub418\uc2dc\uba74 \ub300\uccb4 \uac00\ub2a5 \ud558\uc5ec \uc5ec\ub7ec\uac00\uc9c0 \uae30\ub300 \ud6a8\uacfc\ub3c4 \uc788\uaca0\ub124\uc694.<\/p>\n<p>: \ud504\ub85c\uadf8\ub7a8 \uad6c\ud604 \uc989 SQL\ubb38 \uad6c\ud604\uc2dc \ubcf5\uc7a1\ud568\uc774 \ub35c \ud558\uace0 \ud2b9\ud788 \ud504\ub85c\uc2dc\uc800 \uc0ac\uc6a9\uc2dc \uae30\uc874\uc5d0 VARCHAR2(4000) \uae4c\uc9c0 \uc0ac\uc6a9 \ud588\ub358 \ubc29\uc2dd\uadf8\ub300\ub85c \uae38\uc774\ub9cc \uc870\uc815\ud574\uc11c \uc0ac\uc6a9 \uac00\ub2a5 \ud569\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>2. \ub2e8\uc810<\/strong><\/p>\n<p>: \uae30\uc874 DBMS \uc989 \uc6b4\uc601\uc911 \ub610\ub294 \uc9c0\uae08 \ud604\uc7ac \uac1c\ubc1c \uc911 \uc778 \uacf3\uc740 \ub9ce\uc740 \ud14c\uc2a4\ud2b8\uc640 \uc900\ube44\ub97c \ud55c \ud6c4 \ubcc0\uacbd \ud574 \uc8fc\uc2dc\uae38 \ubc14\ub78d\ub2c8\ub2e4. \uc2e0\uaddc DB \uc11c\ubc84\uc5d0\uc11c \ubd80\ud130 \uc124\uc815\uc744 \uad8c\ud574 \ub4dc\ub9ac\uace0 \uc2f6\uc2b5\ub2c8\ub2e4.<\/p>\n<p>: ORA-14695 \uc5d0\ub7ec\uac00 \ub098\uba74\uc11c DB\uac00 \uc548\uc62c\ub77c \uc635\ub2c8\ub2e4.<\/p>\n<p><strong><span style=\"color: #ff0000;\">: \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\uc2dd\uc774 \ub2e4\ub985\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc8fc\uc758 \ud574 \uc8fc\uc154\uc57c \ud569\ub2c8\ub2e4.<\/span><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>\uc778\ub371\uc2a4 \uc0ac\uc6a9 \ubc29\ubc95\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>#. \ud14c\uc2a4\ud2b8 \ud658\uacbd<\/p>\n<p>select VERSION, EDITION, DATABASE_TYPE from v$instance;<\/p>\n<p>VERSION EDITION DATABASE_TYPE<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;- &#8212;&#8212;&#8212;&#8212;&#8212;<\/p>\n<p><a href=\"https:\/\/l.facebook.com\/l.php?u=http%3A%2F%2F12.2.0.1%2F%3Ffbclid%3DIwAR3LSIy9xK2BlKji4mbYz0SGQN0gNBvdE0L7sMUJyFbwt5ofg4li4nv4GPU&amp;h=AT1OmCrnafZrLTpmiVwg7mU2lxbcpRr8jdetJJUKBlS31kv6re_d3AfcfV4zN-wfB8_MpQDrQyqGBatGmBkpvnaBb7f20j3rqwyTg8V30-eI1-dAwin5QwmD8zQAgmPyDCvU&amp;__tn__=-UK-R&amp;c[0]=AT3h_4MdYZnQPM0_2fBbh63LzeXCzeIuknzBUmpczngSADPXC71lHcu8SB4PvzopjPvKrVnpEVlzRiqumqytsLggsd8OpxZyqwB0GYuIlwl0T4iFE_mLLRFJHE_pyz4gcww_Hhb1JIoN33mYu-l2VoKVaZxi1QV5OFtHKA8fG45EHQ6_8tIyGENfb9-Oxq-05xFnx-QWssxVf7UuYXA\">12.2.0.1<\/a>.0 EE SINGLE<\/p>\n<p>&nbsp;<\/p>\n<p><strong>1) \ud14c\uc774\ube14 \uc0dd\uc131<\/strong><\/p>\n<p>CREATE TABLE TBL_SQLID<\/p>\n<p>(<\/p>\n<p>ONWER VARCHAR2(128),<\/p>\n<p>TABLE_NAME VARCHAR2(128),<\/p>\n<p><strong><span style=\"color: #0000ff;\">SQL_TEXT VARCHAR2(32000),<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #0000ff;\">SQL_ID VARCHAR2(32000),<\/span><\/strong><\/p>\n<p>SQL_ID_COUNT NUMBER,<\/p>\n<p>IN_DATE VARCHAR2(30)<\/p>\n<p>) NOLOGGING;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>2) \uc778\ub371\uc2a4 \uc0dd\uc131<\/strong><\/p>\n<p><strong><span style=\"color: #ff0000;\">ALTER TABLE TBL_SQLID ADD (<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #ff0000;\">SQL_ID_HASH AS (STANDARD_HASH(SQL_ID)),<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #ff0000;\">SQL_TEXT_HASH AS (STANDARD_HASH(SQL_TEXT))<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #ff0000;\">);<\/span><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>ALTER TABLE TBL_SQLID ADD CONSTRAINT PK_TBL_SQLID UNIQUE( SQL_ID_HASH, SQL_TEXT_HASH);<\/p>\n<p>&nbsp;<\/p>\n<p><b>\uc2e4\uc9c8\uc801\uc73c\ub85c \uc218\uc9d1\ud55c \ub370\uc774\ud0c0 \uce74\uc6b4\ud130 \ud55c \ub0b4\uc6a9 \uc785\ub2c8\ub2e4.<\/b><\/p>\n<p><b>SELECT LENGTHB(SQL_ID) FROM TBL_SQLID order by LENGTHB(SQL_ID) DESC NULLS LAST;<\/b><\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p>LENGTHB(SQL_ID)<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;<\/p>\n<p><b>15203<\/b><\/p>\n<p><b>9659<\/b><\/p>\n<p><b>7517<\/b><\/p>\n<p><b>6439<\/b><\/p>\n<p><b>5011<\/b><\/p>\n<p>3723<\/p>\n<p>3625<\/p>\n<p>~~~~~~~~~<\/p>\n<p><img src=\"https:\/\/scontent-gmp1-1.xx.fbcdn.net\/v\/t1.6435-9\/87473757_3013654985351457_9090413387107532800_n.jpg?_nc_cat=101&amp;ccb=1-5&amp;_nc_sid=825194&amp;_nc_ohc=gq_JhGDuKKcAX-BAc3E&amp;_nc_ht=scontent-gmp1-1.xx&amp;oh=08a8fe5f27584b2758feb19d56fe7af9&amp;oe=61A8AF24\" alt=\"\uc0ac\uc9c4 \uc124\uba85\uc774 \uc5c6\uc2b5\ub2c8\ub2e4.\" \/><\/p>\n<p>=======================================<\/p>\n<p>&nbsp;<\/p>\n<p>\ucc38\uace0\ub85c \uc800\ub294 \uc7a5\uc810\uc744 \uc120\ud0dd \ud558\uc5ec \uac00\uae09\uc801 \uc124\uc815\uc744 \ud574 \ub193\uc740 \uc0c1\ud0dc \uc774\uace0, \uac1c\ubc1c\uc790\ubd84\ub4e4\uc5d0\uac8c \uc54c\ub824\ub4dc\ub9ac\uace0 \uc0ac\uc6a9\uc744 \uad8c\ud558\uc9c0\ub9cc, \uacb0\uacfc\uc801\uc73c\ub85c \ubcf4\uba74 \ucc98\uc74c\ubd80\ud130 \uac1c\ubc1c \ub418\uc9c0 \uc54a\uc740 \ud14c\uc774\ube14\uc744 \ubcc0\uacbd\ud574\uc11c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p><a title=\"https:\/\/docs.oracle.com\/database\/121\/REFRN\/GUID-D424D23B-0933-425F-BC69-9C0E6724693C.htm?fbclid=IwAR0bwaa-MPY7RBkyHyfz35s2f3lbnDemm_1_skof64vwccOK4edJ24zEaus#REFRN10321\" href=\"https:\/\/docs.oracle.com\/database\/121\/REFRN\/GUID-D424D23B-0933-425F-BC69-9C0E6724693C.htm?fbclid=IwAR0bwaa-MPY7RBkyHyfz35s2f3lbnDemm_1_skof64vwccOK4edJ24zEaus#REFRN10321\">https:\/\/docs.oracle.com\/database\/121\/REFRN\/GUID-D424D23B-0933-425F-BC69-9C0E6724693C.htm?fbclid=IwAR0bwaa-MPY7RBkyHyfz35s2f3lbnDemm_1_skof64vwccOK4edJ24zEaus#REFRN10321<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; MAX_STRING_SIZE = EXTENDED \uc124\uc815\uc744 \ud558\uac8c \ub418\uba74 varchar2(4000) \uc5d0\uc11c varchar2(32767) \uae4c\uc9c0 \uc0ac\uc6a9\uc774 \uac00\ub2a5 \ud569\ub2c8\ub2e4. &nbsp; \uc624\ub77c\ud074 \ubb38\uc11c https:\/\/docs.oracle.com\/&#8230;\/GUID-D424D23B-0933-425F-BC69&#8230; \uc7a5\uc810\uc740 \ubb34\uc5c7\uc774\uba70 \ub2e8\uc810\uc744 \ubb34\uc5c7\uc774 \uc788\uc744\uae4c\uc694? &nbsp; 1. \uc7a5\uc810 : \uc9c0\uae08\uc740 \uac70\uc758 LONG \ud0c0\uc785\uc774 \uc5c6\uaca0\uc9c0\ub9cc \ub300\uccb4 \uac00\ub2a5 \ud569\ub2c8\ub2e4. : LOB \ud0c0\uc785\uae4c\uc9c0 \uc0ac\uc6a9 \ud560 \ud544\uc694\uc131\uc774 \uc5c6\ub2e4\uace0 \ud310\ub2e8\uc774 \ub418\uc2dc\uba74 \ub300\uccb4 \uac00\ub2a5 \ud558\uc5ec \uc5ec\ub7ec\uac00\uc9c0 \uae30\ub300 \ud6a8\uacfc\ub3c4 \uc788\uaca0\ub124\uc694. : \ud504\ub85c\uadf8\ub7a8 \uad6c\ud604 \uc989 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2069,"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":[1241,1242],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/oracle-database-upgrade-12c.jpg?fit=625%2C325","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4665"}],"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=4665"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4665\/revisions"}],"predecessor-version":[{"id":4667,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4665\/revisions\/4667"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2069"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4665"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4665"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}