{"id":349,"date":"2023-11-28T08:31:40","date_gmt":"2023-11-27T23:31:40","guid":{"rendered":"https:\/\/blog.it-zip.com\/?p=349"},"modified":"2023-11-28T08:31:43","modified_gmt":"2023-11-27T23:31:43","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-%ec%98%a4%eb%a5%98-%ed%95%b4%ea%b2%b0-%eb%b0%a9%eb%b2%95-ora-00907-%eb%88%84%eb%9d%bd%eb%90%9c-%ec%9a%b0%ea%b4%84%ed%98%b8","status":"publish","type":"post","link":"https:\/\/blog.it-zip.com\/it-dev\/db\/%ec%98%a4%eb%9d%bc%ed%81%b4-%ec%98%a4%eb%a5%98-%ed%95%b4%ea%b2%b0-%eb%b0%a9%eb%b2%95-ora-00907-%eb%88%84%eb%9d%bd%eb%90%9c-%ec%9a%b0%ea%b4%84%ed%98%b8\/","title":{"rendered":"\uc624\ub77c\ud074 \uc624\ub958 \ud574\uacb0 \ubc29\ubc95 &#8211; ORA-00907: \ub204\ub77d\ub41c \uc6b0\uad04\ud638"},"content":{"rendered":"\n<p>Database \ucc98\ub9ac \uc911 \ubc1c\uc0dd\ud558\ub294 \uc624\ub958\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\ub824\uace0 \ud55c\ub2e4. \uc624\ub77c\ud074\uc744 \uc0ac\uc6a9\ud558\uba74\uc11c ORA-00907 \uc624\ub958\uac00 \uc0dd\uac01\ubcf4\ub2e4 \uc885\uc885 \ubc1c\uc0dd\ud558\ub294\ub370, \uc6b0\uad04\ud638\ub294 \uc798 \uc37c\ub294\ub370\ub3c4 \ubc1c\uc0dd\ud558\ub294 \uc624\ub958\uc774\uae30 \ub54c\ubb38\uc5d0 \ucd08\ubcf4\uc790\ub4e4\uc740 \ub2f9\ud669\ud560 \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0 \uc27d\uac8c \ud574\uacb0\ud560 \uc218 \uc788\uae30\ub97c \ubc14\ub77c\uba70 \uae00\uc744 \uc791\uc131 \ud574\ubcf4\ub3c4\ub85d \ud55c\ub2e4.<\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>\uc624\ub77c\ud074 \uc624\ub958 \ud574\uacb0 \ubc29\ubc95 &#8211; ORA-00907: \ub204\ub77d\ub41c \uc6b0\uad04\ud638<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\uccab\ubc88\uc9f8 \ub204\ub77d\ub41c \uc6b0\uad04\ud638\ub97c \ucc3e\uc544\ub77c<\/h3>\n\n\n\n<p>\uc624\ub77c\ud074\uc5d0\uc11c \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\ub2e4 \uc885\uc885 \ubc1c\uc0dd\ud558\ub294 \uc624\ub958\uc774\ub2e4. \ub9d0 \uadf8\ub300\ub85c \uc6b0\uad04\ud638\uac00 \ube60\uc84c\uc744 \uacbd\uc6b0 \ubc1c\uc0dd\ud558\ub294 \uc624\ub958\uc774\ub2e4. \uc544\ub798 \uc608\uc2dc\ub85c \ub9cc\ub4e0 \ud14c\uc774\ube14 \uc0dd\uc131 \ucffc\ub9ac\ub97c \ud655\uc778\ud574\ubcf4\ub3c4\ub85d \ud558\uc790.<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>CREATE TABLE TEMP_TBL\n(\nTEMP_1 NUMBER(*,0) NOT NULL ENABLE,\nTEMP_2 VARCHAR2(20 BYTE) NOT NULL ENABLE,\nTEMP_DATE DATE,\nCONSTRAINT PK_TEMP_TBL PRIMARY KEY (TEMP_1)\n;<\/code><\/pre><\/div>\n\n\n\n<p><br><\/p>\n\n\n\n<p>\uc704 \ucffc\ub9ac\uc640 \uac19\uc774 TEMP_TBL \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\ub824\uace0 \ud558\uba74 ORA-00907:\ub204\ub77d\ub41c \uc6b0\uad04\ud638\ub77c\ub294 \uc624\ub77c\ud074 \uc624\ub958\uac00 \ubc1c\uc0dd\ud558\uac8c \ub41c\ub2e4. \uc774\uc720\ub294 \uc55e\uc11c \uc124\uba85\ud55c \uac83\uacfc \uac19\uc774 \uc624\ub958 \ub85c\uadf8 \uadf8\ub300\ub85c \uc6b0\uad04\ud638\uac00 \ube60\uc84c\uae30 \ub54c\ubb38\uc774\ub2e4.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"490\" height=\"246\" src=\"https:\/\/i0.wp.com\/blog.it-zip.com\/wp-content\/uploads\/2023\/11\/\ub204\ub77d\ub41c\uc6b0\uad04\ud6381.png?resize=490%2C246&#038;ssl=1\" alt=\"\" class=\"wp-image-350\" srcset=\"https:\/\/i0.wp.com\/blog.it-zip.com\/wp-content\/uploads\/2023\/11\/\ub204\ub77d\ub41c\uc6b0\uad04\ud6381.png?w=490&amp;ssl=1 490w, https:\/\/i0.wp.com\/blog.it-zip.com\/wp-content\/uploads\/2023\/11\/\ub204\ub77d\ub41c\uc6b0\uad04\ud6381.png?resize=300%2C151&amp;ssl=1 300w\" sizes=\"(max-width: 490px) 100vw, 490px\" data-recalc-dims=\"1\" \/><figcaption class=\"wp-element-caption\">\ub204\ub77d\ub41c \uc6b0\uad04\ud638\ub97c \ucc3e\uc544\ub77c<\/figcaption><\/figure><\/div>\n\n\n<p><br><\/p>\n\n\n\n<p>\ud574\uacb0 \ubc29\ubc95 : \ub204\ub77d\ub41c \uc6b0\uad04\ud638\ub97c \ucc3e\uc544 \uc6b0\uad04\ud638\ub97c \uc791\uc131\ud574\uc900\ub2e4. <br>\uc544\uc8fc \uac04\ub2e8\ud558\uac8c \ud574\uacb0\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uc774\ub2e4. \ud558\uc9c0\ub9cc \ucffc\ub9ac\uac00 \uac04\ub2e8\ud574 \uad04\ud638\ub97c \uc798 \ubabb \uc785\ub825\ud55c \ubd80\ubd84\uc744 \ubc14\ub85c \ucc3e\uc744 \uc218 \uc788\uaca0\uc9c0\ub9cc, \ucffc\ub9ac\uac00 \ubcf5\uc7a1\ud574\uc9c4\ub2e4\uba74 \ucc3e\ub294\ub370 \ub208\uc774 \uc880 \uc544\ud50c\ud14c\ub2c8 \ucc38\uace0\ud558\uba74 \uc88b\uaca0\ub2e4.<\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ub450\ubc88\uc9f8 \ubb34\uc5c7\uc774 \ub610 \ube60\uc84c\ub2e4<\/h3>\n\n\n\n<p>\ub2e4\ub978 \ubb34\uc5c7\uc774 \ucffc\ub9ac\uc5d0\uc11c \ube60\uc838\ub3c4 \uc6b0\uad04\ud638\uac00 \ube60\uc9c4 \uac83\uacfc \uac19\uc740 \uc624\ub77c\ud074 \uc624\ub958\uc778 &#8216;ORA-00907:\ub204\ub77d\ub41c \uc6b0\uad04\ud638&#8217;\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\ub2e4. \uc544\ub798 TEMP_TBL \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\ub294 \ucffc\ub9ac\ub97c \ud55c \ubc88 \ub354 \ud655\uc778\ud574\ubcf4\ub3c4\ub85d \ud558\uc790.<\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>CREATE TABLE TEMP_TBL\n(\nTEMP_1 NUMBER(*,0) NOT NULL ENABLE,\nTEMP_2 VARCHAR2(20 BYTE) NOT NULL ENABLE,\nTEMP_DATE DATE\nCONSTRAINT PK_TEMP_TBL PRIMARY KEY (TEMP_1)\n);<\/code><\/pre><\/div>\n\n\n\n<p>\ucc3e\uc744 \uc218 \uc788\ub2e4\uba74 \ub2f9\uc2e0\uc740 \ucd08\ubcf4\uac00 \uc544\ub2c8\ub2e4. \uc815\ub2f5\uc740 \ubc14\ub85c \ucf64\ub9c8(,)\uac00 \ube60\uc84c\uae30 \ub54c\ubb38\uc5d0 \uc624\ub77c\ud074 \uc624\ub958(ORA-00907:\ub204\ub77d\ub41c \uc6b0\uad04\ud638)\uac00 \ubc1c\uc0dd\ud588\ub358 \uac83\uc774\ub2e4. \uc624\ub958 \ub85c\uadf8\ub294 \uc544\ub798 \uc774\ubbf8\uc9c0\uc640 \uac19\ub2e4.<\/p>\n\n\n\n<p><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"497\" height=\"271\" src=\"https:\/\/i0.wp.com\/blog.it-zip.com\/wp-content\/uploads\/2023\/11\/\ub204\ub77d\ub41c\uc6b0\uad04\ud6382.png?resize=497%2C271&#038;ssl=1\" alt=\"\" class=\"wp-image-351\" srcset=\"https:\/\/i0.wp.com\/blog.it-zip.com\/wp-content\/uploads\/2023\/11\/\ub204\ub77d\ub41c\uc6b0\uad04\ud6382.png?w=497&amp;ssl=1 497w, https:\/\/i0.wp.com\/blog.it-zip.com\/wp-content\/uploads\/2023\/11\/\ub204\ub77d\ub41c\uc6b0\uad04\ud6382.png?resize=300%2C164&amp;ssl=1 300w\" sizes=\"(max-width: 497px) 100vw, 497px\" data-recalc-dims=\"1\" \/><figcaption class=\"wp-element-caption\">\ucf64\ub9c8\uac00 \ube60\uc9c4 \uc624\ub958 \ub85c\uadf8(ORA-00907:\ub204\ub77d\ub41c \uc6b0\uad04\ud638)<\/figcaption><\/figure><\/div>\n\n\n<p><br><\/p>\n\n\n\n<p>\ud574\uacb0 \ubc29\ubc95 : \ub204\ub77d\ub41c \ucf64\ub9c8(,)\ub97c \ucc3e\uc544 \uc791\uc131\ud574\uc900\ub2e4. <br>\uc5b4\ub835\uc9c0 \uc54a\uac8c \ud574\uacb0\ud560 \uc218 \uc788\ub294 \uc624\ub77c\ud074 \uc624\ub958\uc774\ub2e4. \ub450 \uac00\uc9c0 \ubc29\ubc95\uc744 \uc54c\uace0 \uc788\ub2e4\uac00 \ud574\ub2f9 \uc624\ub958\uac00 \ubc1c\uc0dd\ud588\uc744 \uacbd\uc6b0 \uc544\uc8fc \uc27d\uac8c \ucc98\ub9ac\ud558\uae38 \ubc14\ub780\ub2e4.<\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ucc38\uace0\ub85c \uc67c\ucabd \uad04\ud638\uac00 \ube60\uc84c\uc744 \uacbd\uc6b0?<\/h3>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"473\" height=\"260\" src=\"https:\/\/i0.wp.com\/blog.it-zip.com\/wp-content\/uploads\/2023\/11\/\ub204\ub77d\ub41c\uc6b0\uad04\ud6383.png?resize=473%2C260&#038;ssl=1\" alt=\"\" class=\"wp-image-352\" srcset=\"https:\/\/i0.wp.com\/blog.it-zip.com\/wp-content\/uploads\/2023\/11\/\ub204\ub77d\ub41c\uc6b0\uad04\ud6383.png?w=473&amp;ssl=1 473w, https:\/\/i0.wp.com\/blog.it-zip.com\/wp-content\/uploads\/2023\/11\/\ub204\ub77d\ub41c\uc6b0\uad04\ud6383.png?resize=300%2C165&amp;ssl=1 300w\" sizes=\"(max-width: 473px) 100vw, 473px\" data-recalc-dims=\"1\" \/><figcaption class=\"wp-element-caption\">\ucc38\uace0\ub85c \uc67c\ucabd \uad04\ud638\uac00 \ube60\uc84c\uc744 \uacbd\uc6b0<\/figcaption><\/figure><\/div>\n\n\n<p>\uc6b0\uad04\ud638\uac00 \ube60\uc84c\uc744 \uacbd\uc6b0 ORA-00097: \ub204\ub77d\ub41c \uc6b0\uad04\ud638 \uc624\ub958 \ub85c\uadf8\ub97c \ud655\uc778\ud560 \uc218 \uc788\uc9c0\ub9cc, \uc88c\uad04\ud638? \uc67c\ucabd \uad04\ud638\uac00 \ube60\uc84c\uc744 \uacbd\uc6b0\uc5d0\ub294 \ub2e4\ub978 \uc624\ub958 \ub85c\uadf8\uac00 \ud655\uc778\ub418\ub2c8 \ucc38\uace0\ud558\uae38 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uadf8 \uc624\ub958 \ub85c\uadf8\ub294 ORA-00922: \ub204\ub77d\ub41c \ub610\ub294 \ubd80\uc801\ud569\ud55c \uc635\uc158 \uc774\ub77c\uace0 \ucd9c\ub825 \ub41c\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database \ucc98\ub9ac \uc911 \ubc1c\uc0dd\ud558\ub294 \uc624\ub958\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\ub824\uace0 \ud55c\ub2e4. \uc624\ub77c\ud074\uc744 \uc0ac\uc6a9\ud558\uba74\uc11c ORA-00907 \uc624\ub958\uac00 \uc0dd\uac01\ubcf4\ub2e4 \uc885\uc885 \ubc1c\uc0dd\ud558\ub294\ub370, \uc6b0\uad04\ud638\ub294 \uc798 \uc37c\ub294\ub370\ub3c4 \ubc1c\uc0dd\ud558\ub294 \uc624\ub958\uc774\uae30 \ub54c\ubb38\uc5d0 \ucd08\ubcf4\uc790\ub4e4\uc740 \ub2f9\ud669\ud560 \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0 \uc27d\uac8c \ud574\uacb0\ud560 \uc218 \uc788\uae30\ub97c \ubc14\ub77c\uba70 \uae00\uc744 \uc791\uc131 \ud574\ubcf4\ub3c4\ub85d \ud55c\ub2e4. \uc624\ub77c\ud074 \uc624\ub958 \ud574\uacb0 \ubc29\ubc95 &#8211; ORA-00907: \ub204\ub77d\ub41c \uc6b0\uad04\ud638 \uccab\ubc88\uc9f8 \ub204\ub77d\ub41c \uc6b0\uad04\ud638\ub97c \ucc3e\uc544\ub77c \uc624\ub77c\ud074\uc5d0\uc11c \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\ub2e4 \uc885\uc885 \ubc1c\uc0dd\ud558\ub294 \uc624\ub958\uc774\ub2e4. \ub9d0 \uadf8\ub300\ub85c &#8230; <a title=\"\uc624\ub77c\ud074 \uc624\ub958 \ud574\uacb0 \ubc29\ubc95 &#8211; ORA-00907: \ub204\ub77d\ub41c \uc6b0\uad04\ud638\" class=\"read-more\" href=\"https:\/\/blog.it-zip.com\/it-dev\/db\/%ec%98%a4%eb%9d%bc%ed%81%b4-%ec%98%a4%eb%a5%98-%ed%95%b4%ea%b2%b0-%eb%b0%a9%eb%b2%95-ora-00907-%eb%88%84%eb%9d%bd%eb%90%9c-%ec%9a%b0%ea%b4%84%ed%98%b8\/\" aria-label=\"Read more about \uc624\ub77c\ud074 \uc624\ub958 \ud574\uacb0 \ubc29\ubc95 &#8211; ORA-00907: \ub204\ub77d\ub41c \uc6b0\uad04\ud638\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":353,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[117],"tags":[177,176,175,178,179],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/blog.it-zip.com\/wp-content\/uploads\/2023\/11\/\ub204\ub77d\ub41c\uc6b0\uad04\ud638_\uba54\uc778.png?fit=1180%2C664&ssl=1","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/blog.it-zip.com\/wp-json\/wp\/v2\/posts\/349"}],"collection":[{"href":"https:\/\/blog.it-zip.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.it-zip.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.it-zip.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.it-zip.com\/wp-json\/wp\/v2\/comments?post=349"}],"version-history":[{"count":2,"href":"https:\/\/blog.it-zip.com\/wp-json\/wp\/v2\/posts\/349\/revisions"}],"predecessor-version":[{"id":355,"href":"https:\/\/blog.it-zip.com\/wp-json\/wp\/v2\/posts\/349\/revisions\/355"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.it-zip.com\/wp-json\/wp\/v2\/media\/353"}],"wp:attachment":[{"href":"https:\/\/blog.it-zip.com\/wp-json\/wp\/v2\/media?parent=349"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.it-zip.com\/wp-json\/wp\/v2\/categories?post=349"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.it-zip.com\/wp-json\/wp\/v2\/tags?post=349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}