Changing the minimum partition value in an interval partitioned table
I have an interval partitioned table that I would like to change the minimum partition value on and I'm not sure how to do it. For example I have a table that is partitioned on say BIRTHDATE. For example:
CREATE TABLE person (uid NUMBER, birthdate date, ....)
PARTITION BY RANGE (birthdate)
INTERVAL (NUMTOYMINTERVAL(1,'month')
(PARTITION p_first VALUES LESS THAN ('01-JAN-1975'));
However, I know my minimum value will never be less than say '01-JAN-2000' so I want to change that "p_first" partition to have values less than 01-JAN-2000. Is there a simple ALTER TABLE command I could issue or do I have to re-create the entire table with the new min partition value? You might ask why I care...well, that's a long store but it does matter from a performance standpoint.
CREATE TABLE person (uid NUMBER, birthdate date, ....)
PARTITION BY RANGE (birthdate)
INTERVAL (NUMTOYMINTERVAL(1,'month')
(PARTITION p_first VALUES LESS THAN ('01-JAN-1975'));
However, I know my minimum value will never be less than say '01-JAN-2000' so I want to change that "p_first" partition to have values less than 01-JAN-2000. Is there a simple ALTER TABLE command I could issue or do I have to re-create the entire table with the new min partition value? You might ask why I care...well, that's a long store but it does matter from a performance standpoint.
0