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:

Read more in Oracle Documentation

 

Truncate multiple partitions example:

Read more in Oracle Documentation

 

Drop multiple partitions example:

Read more in Oracle Documentation

 

 

 

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:

If range partitions are merged, you may use the “TO” clause.

Read more about this feature and restrictions in Oracle Documentation.

Splitting Partitions Example:

Read more in Oracle Documentation

 

 

%d bloggers like this: