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 IN ( <partition_value_list>),...
CREATE TABLE athlete2( name VARCHAR(40), event VARCHAR(30)
)
PARTITION BY LIST (event) (
PARTITION event1 VALUES IN ('Swimming', 'Athletics ' ),
PARTITION event2 VALUES IN ('Judo', 'Taekwondo','Boxing'),
PARTITION event3 VALUES IN ('Football', 'Basketball', 'Baseball')
);
ALTER TABLE athlete2 REORGANIZE PARTITION event2 INTO
(PARTITION event2_1 VALUES IN ('Judo'),
PARTITION event2_2 VALUES IN ( 'Taekwondo','Boxing'));
ALTER TABLE athlete2 REORGANIZE PARTITION event2_1,
event2_2 INTO
(PARTITION event2 VALUES IN('Judo','Taekwondo','Boxing'));