Below are the partitioning enhancements that has been introduced in Oracle 12c version.

1. Online partition move:

From oracle 12c, we can move partitions online without blocking the DML statements during that time.

ALTER TABLE DBACLASS MOVE PARTITION DBA_JAN2014 ONLINE;

— To maintain global indexes

ALTER TABLE DBACLASS MOVE PARTITION DBA_JAN2014 ONLINE UPDATE GLOBAL INDEXES;

— Moving to another tablespace:

ALTER TABLE DBACLASS MOVE PARTITION DBACLASS_JAN2014 ONLINE TABLESPACE TESTTS UPDATE INDEXES;

2. Adding multiple partitions with One command:

ALTER TABLE CMADMIN.DBACLASS ADD
PARTITION DBACLASS_JAN VALUES LESS THAN (TO_DATE('01-FEB-2016','DD-MON-YYYY')) TABLESPACE USERS,
PARTITION DBACLASS_FEB VALUES LESS THAN (TO_DATE('01-MAR-2016','DD-MON-YYYY')) TABLESPACE USERS,
PARTITION DBACLASS_MAR VALUES LESS THAN (TO_DATE('01-APR-2016','DD-MON-YYYY')) TABLESPACE USERS,
UPDATE GLOBAL INDEXES;

3. Drop/Truncate multiple partitions with one command:

—For Drop

ALTER TABLE CMADMIN.DBACLASS DROP PARTITIONS DBACLASS_JAN, DBACLASS_FEB, DBACLASS_MAR UPDATE GLOBAL INDEXES;

— For truncate

ALTER TABLE CMADMIN.DBACLASS DROP PARTITIONS DBACLASS_JAN, DBACLASS_FEB, DBACLASS_MAR UPDATE GLOBAL INDEXES;

4. Merging multiple partitions to single partition

— NOTE: UPDATE GLOBAL INDEXES is required if GLOBAL INDEX is present

ALTER TABLE CMADMIN.DBACLASS MERGE PARTITIONS 
DBACLASS_JAN, DBACLASS_FEB, DBACLASS_MAR 
INTO partition DBACLASS_Q1;

5. Splitting single partition to multiple partitions:

ALTER TABLE CMADMIN.DBACLASS SPlIT PARTITIONS DBACLASS_Q1 INTO
(PARTITION DBACLASS_JAN values less than (TO_DATE('01-FEB-2016','dd-MON-yyyy')),
PARTITION DBACLASS_FEB values less than (TO_DATE('01-MAR-2016','dd-MON-yyyy')),
PARTITION DBACLASS_MAR);

SEE OTHER ORACLE 12C ARTICLES: