partitioning – Page 4 – Learning is not a spectator sport

A cool thing with EXCHANGE PARTITION (part 2)

In the previous post, I showed that even though a partition was “removed” (ie, exchanged out) from a table, a

Had an interesting AskTom question today about dynamically keeping partition sizes in check. The poster had large table, already partitioned,

A while back I did a blog post showing that when you have set a column to UNUSED, it still

In 12c, one of the nice changes to come along is that partition maintenance operations can now be done on

As a DBA, its awesome when you have the Partitioning option at your disposal. So many cool things suddenly become

So…you have got a big table and you’re lucky enough to have a partitioning license. So far, so good. Then

I should stress that this is all well covered in the documentation, but it was something I stumbled upon just

My Oracle Support had a fairly lengthy outage today right in the middle of the Australian business day. But I’m