交换分区测试

create table test1(x int)
partition by range(x)
(
partition x1 values less than (1),
partition x2 values less than (10),
partition x3 values less than (100)

);

create table test2(x int)

alter table test1 exchange partition x2 with table test2 without validation;

select * from test1 partition(x2) t;