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: 指定的分区不存在为什么会这样?高手指点下;
partition a56分区不存在
---------------
alter table t_v1 merge partitions a5,a6 into partition a5;
不能将其它表的分区合并到t_v1中来这个是查询所有表的分区
select distinct partition_name from user_tab_partitions应该只查询T_V1的分区,看有没有a5,a6
select partition_name from user_tab_partitions t where t.table_name='T_V1';