In times past, this could be large problem for us: some incoming data had typo'd dates (on our partitioning key), so the value could be far beyond our partitions. Or sometimes the dates were valid, but just beyond the extent of the extant partitions. Either way, things would go "bump in the night". And I need my beauty sleep.

Then I wondered: how do I know which partitioned tables have interval partitioning? I'm "intervalizing" as I go, now that we've converted to 11g from 10g, but how do I know what's been done and what's left?