OracleDB12c New Feature: Merging and Splitting Multiple Partitions
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 … Read more