I have a large table which I want to parition using a date (DD-MON-YY) as the partition key.
Can I partition this table online? If so, How?
Also, if I have 5 partitions and partition 5 was ranged from '01-Nov-01' to '30-Nov-01' and the last partition was <(MAXVALUE)) .... Can I create another partition (in the future), e.g. partition 6 for '01-Dec-01' to '31-Dec-01', and still have the last partition as <(MAXVALUE) online?