ALTER 문의 REORGANIZE PARTITION 절을 이용하여 분할을 재정의한다. 재정의를 통해 복수개의 분할을 1개에 결합할 수 있으며, 1개의 분할을 복수개로 분리할 수 있다.
ALTER {TABLE
| CLASS} <table_name>
REORGANIZE
PARTITION
<alter
partition name comma list>
INTO ( <partition
definition comma list> )
partition
definition comma list:
PARTITION
<partition_name> VALUES LESS THAN ( <range_value> ),....
CREATE TABLE participant2 ( host_year INT, nation CHAR(3),
gold INT, silver INT, bronze INT)
PARTITION BY RANGE (host_year)
( PARTITION before_2000 VALUES LESS THAN (2000),
PARTITION before_2008 VALUES LESS THAN (2008) );
ALTER TABLE participant2 REORGANIZE PARTITION before_2000
INTO (
PARTITION before_1996 VALUES LESS THAN (1996),
PARTITION before_2000 VALUES LESS THAN (2000)
);
ALTER TABLE participant2 REORGANIZE PARTITION before_1996,
before_2000 INTO
(PARTITION before_2000 VALUES LESS THAN (2000) );