mysql 分区表合并_Oracle 11g: 合并分区表-merge partition

使用ALTER TABLE .. MERGE PARTITION语句将两个分区的内容合并到另外一个分区，两个源分区和关联的local index都会被drop，不能用

Merging Partitions

使用ALTER TABLE .. MERGE PARTITION语句将两个分区的内容合并到另外一个分区，两个源分区和关联的local index都会被drop

不能用于 hash分区表或 hash subpartitions of a composite *-hash partitioned table

不能用于合并引用分区表(reference-partitioned table)

合并范围分区

允许合并两个临近范围的分区到另外分区，不相邻分区无法合并。合并结果分区继承两个源分区的最大边界。

demo:

-- Create a Table with four partitions each on its own tablespace

-- Partitioned by range on the data column.

CREATE TABLE four_seasons

(

one DATE,

two VARCHAR2(60),

three NUMBER

)

PARTITION BY RANGE ( one )

(

PARTITION quarter_one

VALUES LESS THAN ( TO_DATE('01-apr-1998','dd-mon-yyyy'))

TABLESPACE quarter_one,

PARTITION quarter_two

VALUES LESS THAN ( TO_DATE(&#