有这么一张表:
create table test_list_range(vl1 varchar2(20),vl2 number(12))
partition by list(vl1)
subpartition by range(vl2)
(
partition p1 values ('MIN','HOUR')
(
subpartition p1_1 values less than (100000),
subpartition p1_2 values less than (200000),
subpartition p1_3 values less than (300000)
),
partition p2 values ('DAY','MONTH')
(
subpartition p2_1 values less than (100000),
subpartition p2_2 values less than (200000),
subpartition p2_3 values less than (300000)
) ,
partition p3 values ('YEAR')
(
subpartition p3_1 values less than (100000),
subpartition p3_2 values less than (200000),
subpartition p3_3 values less than (300000)
) );
将p1分区跟p2分区合并
alter table test_list_range merge partitions p1,p2 into partition p12;
如何将p12分区split成partition1和partition2呢?
我试了下面的语句:
alter table test_list_range split partition p12 at ('DAY','MONTH') into ( partition1,partition2 );
提示错误:
ORA-14004: missing PARTITION keyword 怎么改动?~~~
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货