Partitioning Enhancements in Oracle Database 12c Release 1


I was planning to cover this subject in a single article, but it got a bit bulky, so I split it down into 6 little articles.

I’ve also created a links page to bring them all together.

I guess you could call it a list of nice-to-haves, rather than something revolutionary, but I’m sure someone will come back to me saying one of them has changed their life! 🙂



Author: Tim...

DBA, Developer, Author, Trainer.

2 thoughts on “Partitioning Enhancements in Oracle Database 12c Release 1”

  1. The cascade functionality for EXCHANGE and TRUNCATE is going to be a God-send for me!
    Something else I found out recently: in 11gr2, interval partitioning works perfectly well with the partition column being of type TIMESTAMP, even though 99% of the examples out there are for either DATE or NUMBER.
    I guess it’s a logical consequence of INTERVAL being defined as the outcome of an INTERVAL function operation and those accept various data types as source.

Comments are closed.