{"id":4638,"date":"2021-11-04T11:18:46","date_gmt":"2021-11-04T02:18:46","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=4638"},"modified":"2021-11-04T11:21:32","modified_gmt":"2021-11-04T02:21:32","slug":"%ed%8c%8c%ed%8b%b0%ec%85%98-%eb%b3%80%ea%b2%bd-online-%ec%9e%91%ec%97%85%ec%9c%bc%eb%a1%9c-%ea%b0%80%eb%8a%a5-%ed%95%a9%eb%8b%88%eb%8b%a4-oracle-18c","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=4638","title":{"rendered":"\ud30c\ud2f0\uc158 \ubcc0\uacbd Online \uc791\uc5c5\uc73c\ub85c \uac00\ub2a5 ( Oracle 18C ~ )"},"content":{"rendered":"

Online Partition Maintenance<\/span><\/strong><\/p>\n

 <\/p>\n

Online Partition and Subpartition Maintenance Operations <\/strong><\/p>\n

 <\/p>\n

#. \ubc84\uc804\uc5d0 \ub530\ub978 Online Operation<\/u><\/p>\n

Oracle 11g<\/span><\/strong> : CREATE INDEX ALTER TABLE ADD COLUMN<\/p>\n

| ADD CONSTRAINT<\/p>\n

 <\/p>\n

Oracle 12c<\/strong><\/span> : DROP INDEX ALTER INDEX UNUSABLE<\/p>\n

ALTER TABLE DROP CONSTRAINT<\/p>\n

| SET COLUMN UNUSED<\/p>\n

| MOVE<\/p>\n

| MOVE PARTITION<\/p>\n

| SPLIT PARTITION<\/p>\n

| MODIFY nonpartitioned to partitioned<\/p>\n

| MOVE PARTITION INCLUDING ROWS<\/p>\n

 <\/p>\n

SQL> ALTER INDEX hr.i_emp_ix <\/span>UNUSABLE ONLINE<\/span>;<\/strong><\/p>\n

 <\/p>\n

 <\/p>\n

#. Oracle 18\ub294 \uc544\ub798\uc640 \uac19\uc740 \ud30c\ud2f0\uc158 \uc791\uc5c5\uc774 Online\uc73c\ub85c \uac00\ub2a5 \ud569\ub2c8\ub2e4.<\/span><\/strong><\/p>\n

\u00a0<\/span><\/p>\n

ALTER TABLE MODIFY :repartitioning, add or remove subpartitioning<\/span><\/strong><\/p>\n

ALTER TABLE MERGE PARTITION<\/span><\/strong><\/p>\n

 <\/p>\n

\"image\"<\/a><\/p>\n

 <\/p>\n

\"image\"<\/a><\/p>\n

 <\/p>\n

\"image\"<\/a>‘<\/p>\n

 <\/p>\n

\"image\"<\/a><\/p>\n

 <\/p>\n

\u2022\u00a0 \uc704\uc758 Modify Partition \uad6c\ubb38\uc740 Online \ud0a4\uc6cc\ub4dc\uac00 \uc788\uc74c\uc73c\ub85c nonblocking \ubaa8\ub4dc\ub85c \uc2e4\ud589 \ub429\ub2c8\ub2e4. <\/strong><\/p>\n

\u2022\u00a0 1\ubc88 \uc778\ub371\uc2a4\ub294 LOCAL\ub85c \uc9c0\uc815\ub418\uc5c8\uc74c\uc73c\ub85c Range-Hash Partitioning\uc774 \ub418\uace0, 2\ubc88 \uc778\ub371\uc2a4\ub294 Global Range Partitioning \uc774 \ub429\ub2c8\ub2e4.<\/strong><\/p>\n

\u2022\u00a0 Update Indexes \uc808\uc5d0 \uc9c0\uc815\ub418\uc9c0 \uc54a\uc740 3\ubc88 \uc778\ub371\uc2a4\uc758 \uacbd\uc6b0 \uc790\ub3d9\uc73c\ub85c Global Nonpartitioned Index\uac00 \ub429\ub2c8\ub2e4.<\/strong><\/p>\n

\u2022\u00a0 \ub9cc\uc57d \uc9c0\uc815\ub418\uc9c0 \uc54a\uc740 \uc778\ub371\uc2a4\uc758 \uccab\ubc88\uc9f8 \uceec\ub7fc\uc774 \uc11c\ube0c\ud30c\ud2f0\uc158 \ud0a4(custno)\uc640 \uac19\ub2e4\uba74 \uc790\ub3d9\uc73c\ub85c Local Partitioned Index\uac00 \ub429\ub2c8\ub2e4.<\/strong><\/p>\n

 <\/p>\n

Online MERGE Partition and Subpartition<\/span><\/strong><\/p>\n

\"image\"<\/a><\/p>\n

 <\/p>\n

\"image\"<\/a><\/p>\n

 <\/p>\n

\uc11c\ube0c \ud30c\ud2f0\uc158\ub3c4 \uac19\uc740 \ubc29\uc2dd\uc73c\ub85c \uc218\ud589 \uac00\ub2a5 \ud569\ub2c8\ub2e4.<\/span><\/strong><\/p>\n

\"image\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

\u00a0<\/span><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

Online Partition Maintenance   Online Partition and Subpartition Maintenance Operations   #. \ubc84\uc804\uc5d0 \ub530\ub978 Online Operation Oracle 11g : CREATE INDEX ALTER TABLE ADD COLUMN | ADD CONSTRAINT   Oracle 12c : DROP INDEX ALTER INDEX UNUSABLE ALTER TABLE DROP CONSTRAINT | SET COLUMN UNUSED | MOVE | MOVE PARTITION | SPLIT PARTITION | MODIFY […]<\/p>\n","protected":false},"author":1,"featured_media":3739,"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":[20],"tags":[1060,1216,164],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/03\/Capture18c000.png?fit=470%2C270","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4638"}],"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=4638"}],"version-history":[{"count":3,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4638\/revisions"}],"predecessor-version":[{"id":4641,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4638\/revisions\/4641"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/3739"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4638"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4638"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4638"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}