{"id":135,"date":"2013-07-05T12:12:49","date_gmt":"2013-07-05T17:12:49","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=135"},"modified":"2026-02-07T15:35:10","modified_gmt":"2026-02-07T21:35:10","slug":"oracledb12c-new-feature-merging-and-splitting-multiple-partitions","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2013\/135\/","title":{"rendered":"OracleDB12c New Feature: Merging and Splitting Multiple Partitions"},"content":{"rendered":"<p>In Oracle11g, you can merge or split two partitions. This feature is enhanced in 12c to merge and split multiple partitions in a single SQL thus reducing the maintenance operations. When merging range partitions, they must be adjacent.<\/p>\n<p>Merging Partitions Example:<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">ALTER TABLE SALESDATA\nMERGE PARTITIONS S2012Q1, S2012Q2, S2012Q3, S2012Q4 INTO S2012;<\/pre>\n<p>If range partitions are merged, you may use the &#8220;TO&#8221; clause.<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">ALTER TABLE SALESDATA\nMERGE PARTITIONS S2012Q1 TO S2012Q4 INTO S2012;<\/pre>\n<p>Read more about this feature and restrictions in <a title=\"Merging Multiple Partitions\" href=\"http:\/\/docs.oracle.com\/cd\/E16655_01\/server.121\/e17613\/part_admin002.htm#autoId53\" target=\"_blank\">Oracle Documentation<\/a>.<\/p>\n<p>Splitting Partitions Example:<\/p>\n<pre class=\"lang:default highlight:0 decode:true crayon-selected\">ALTER TABLE SALESDATA SPLIT PARTITION S2014 INTO\n(PARTITION S2014Q1 VALUES LESS THAN TO_DATE('01-APR-14','DD-MON-YY')),\n(PARTITION S2014Q2 VALUES LESS THAN TO_DATE('01-JUL-14','DD-MON-YY')),\n(PARTITION S2014Q3 VALUES LESS THAN TO_DATE('01-OCT-14','DD-MON-YY')),\n(PARTITION S2014Q4 );<\/pre>\n<p>Read more in <a title=\"Splitting into multiple partitions\" href=\"http:\/\/docs.oracle.com\/cd\/E16655_01\/server.121\/e17613\/part_admin002.htm#autoId96\" target=\"_blank\">Oracle Documentation<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Oracle11g, you can merge or split two partitions. This feature is enhanced in 12c to merge and split multiple partitions in a single SQL thus reducing the maintenance operations. When merging range partitions, they must be adjacent. Merging Partitions Example: ALTER TABLE SALESDATA MERGE PARTITIONS S2012Q1, S2012Q2, S2012Q3, S2012Q4 INTO S2012; If range partitions &#8230; <a title=\"OracleDB12c New Feature: Merging and Splitting Multiple Partitions\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2013\/135\/\" aria-label=\"Read more about OracleDB12c New Feature: Merging and Splitting Multiple Partitions\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[133],"tags":[40,60],"class_list":["post-135","post","type-post","status-publish","format-standard","hentry","category-oracledb","tag-oracle-12c","tag-partition"],"acf":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/135","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=135"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/135\/revisions"}],"predecessor-version":[{"id":3033,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/135\/revisions\/3033"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}