Oracle 23c New Features for DBA'sBefore to 12c, if you want to maintain partitions you will need to execute that many alter statements partition commands that many times.
For example to add p7,p8 partitions, you have to use
SQL> alter table test_tbl add partition p7 values less than (7) SQL> alter table test_tbl add partition p8 values less than (8)
12c has simplified this for following operations in a single Alter commmand.
ADD Multiple partitions/SUB partitions DROP Multiple partitions/SUB partitions MERGE multiple partitions/SUB partitions TRUNCATE multiple partitions
Let's have a quick look
Add Multiple partitions
SQL> alter table test_tbl add partition p7 values less than (7),partition p8 values less than(8); Table altered.
Drop Multiple partitions
SQL> alter table test_tbl drop partition p7,p8; Table altered.
Merge Multiple partitions
SQL> alter table test_tbl merge partitions p7,p8 into partition p9; Table altered.
Split Multiple partitions
SQL> alter table test_tbl split partition p9 into ( partition p7 values less than(7), partition p8 ); Table altered.
Truncate Multiple partitions
SQL> alter table test_tbl truncate partitions p6,p7,p8; Table truncated.
Follow Me!!!