[tip] 마지막 partition key value 값을 maxvalue로 바꾸기

create table test_partition (a number(2))
            partition by range(a)
            (partition  p01 values less than (10) ,
             partition  p02 values less than (20) ,
             partition  p03 values less than (99) );

ALTER TABLE test_partition
 ADD PARTITION p04 VALUES LESS THAN (MAXVALUE) ;

ALTER TABLE test_partition
  MERGE PARTITIONS p03, p04 INTO PARTITION p04 ;

alter table test_partition rename partition p04 to p03;

참고 : Oracle Technical iSeminar - Partition Table과 Index 관리