Kevin - This sounds similar to a partitioning issue that I was able to
resolve. My suggestion is to consider partitioning on a concatenated key,
INVOICE_STATE, UPDATE_DATE. You'll have to play with it, the partitions
don't work the way you think they do. As I recall, if you say "less than
'AL', '0
Thanks to Dennis, I found that partitioning on a concatenated key solves my
dilema.
For those who are interested, here is my new partitioning clause:
PARTITION BY RANGE (invoice_state, update_date) (
PARTITION inv_active VALUES LESS THAN
('B', TO_DATE('01-jan-', 'DD-M