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.
- Partition Maintenance Operations on Multiple Partitions in Oracle Database 12c Release 1
- Partial Indexes for Partitioned Tables in Oracle Database 12c Release 1
- Online Move of Partitions and Sub-Partitions in Oracle 12c Release 1
- Interval-Reference Partitioning in Oracle Database 12c Release 1
- Cascade Functionality for TRUNCATE PARTITION and EXCHANGE PARTITION in Oracle Database 12c Release 1
- Asynchronous Global Index Maintenance for DROP and TRUNCATE Partition in Oracle Database 12c Release 1
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! π
Cheers
Tim…
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.
Noons: You best be getting your folks to let you upgrade to 12c. π
Cheers
Tim…