SQL> select distinct partition_name from user_tab_partitions;PARTITION_NAME
------------------------------
A1
A2
A3
A4
A5
A6
SQL> alter table t_v1 merge partitions a5,a6 into partition a56;
alter table t_v1 merge partitions a5,a6 into partition a56
*
第 1 行出现错误:
ORA-02149: 指定的分区不存在为什么会这样?高手指点下;
------------------------------
A1
A2
A3
A4
A5
A6
SQL> alter table t_v1 merge partitions a5,a6 into partition a56;
alter table t_v1 merge partitions a5,a6 into partition a56
*
第 1 行出现错误:
ORA-02149: 指定的分区不存在为什么会这样?高手指点下;
要先新建个a56区?
select PARTITION_NAME from user_tab_partitions t where t.table_name='T_V1';
合并后的分区不需要先创建
select distinct partition_name from user_tab_partitions
WHERE table_name='T_V1';
2 partition by list(v) (partition p1 values('a','b'),
3 partition p2 values('c','d'));表已创建。SQL> alter table pt merge partitions p1,p2 into partition p02;表已更改。SQL>