Hi, HPUX 11.2.0.3.0
I have many 0.5billion row range partitioned (date) with a one month "interval"
tables, so
create table foo
(
loads of columns
) ......
......
tablespace "baa"
partition by range(dateCOlumn)
interval (numtoyminterval(1,'MONTH'))
(partition initial values less than (to_date('01-01-1900','DD-MM-YYYY'))
);
I am considering index partitioning too, however index interval partitioning
appears to not be supported in 11.2.
Partitions will be scheduled to be dropped periodically and I need to concern
myself with efficient index rebuilding/dropping.
Has anyone found themselves in this Oracle interval partitioning supported for
tables but not the underlying indexes dilemma before and, if so, how you
approached the problem?
All feedback appreciated.
Mike
—
Michael D O'Shea
Woodward Informatics Ltd, http://www.strychnine.co.uk ;
<http://www.strychnine.co.uk/>