Database DataWarehousing (MOSC)

MOSC Banner

Changing the minimum partition value in an interval partitioned table

edited Jan 14, 2010 12:44AM in Database DataWarehousing (MOSC) 7 comments
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center