oracle-12c

Yesterday, we discussed merging and splitting multiple partitions. The same feature is extended in 12c to add, drop or truncate multiple partitions in a single SQL statement. Add multiple partitions example: ALTER TABLE SALESDATA ADD PARTITION S2015Q1 VALUES LESS THAN (TO_DATE(’01-APR-15′,’DD-MON-YY’)), PARTITION S2015Q2 VALUES LESS THAN (TO_DATE(’01-JUL-15′,’DD-MON-YY’)), PARTITION S2015Q3 VALUES LESS THAN (TO_DATE(’01-OCT-15′,’DD-MON-YY’)), PARTITION S2015Q4 … Read more

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