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.

— To maintain global indexes

— Moving to another tablespace:

2. Adding multiple partitions with One command:

3. Drop/Truncate multiple partitions with one command:

—For Drop

— For truncate

4. Merging multiple partitions to single partition

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

5. Splitting single partition to multiple partitions:

SEE OTHER ORACLE 12C ARTICLES: