OracleDB12c New Feature: Adding, Dropping, Truncating Multiple Partitions

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

 

 

 

Leave a Reply

%d bloggers like this: