Oracle：两个分区表之间exchange分区体验

1. 创建初始分区表结构

create table test_partition (
id number,
ac_dt VARCHAR2(8),
c3 number,
c4 varchar2(8))
partition by range (ac_dt)
(partition test_p1      values less than ('20210101') tablespace users,
partition test_20210101 values less than ('20210102') tablespace users,
partition test_20210102 values less than ('20210103') tablespace users,
partition test_20210103 values less than ('20210104') tablespace users
)
tablespace users;

--测试数据insert
insert into test_partition values(1,'20201220',1,'20201220');
insert into test_partition values(2,'20201220',2,'20201220');
insert into test_partition values(3,'20210101',3,'20210101');
insert into test_partition