add partition成功,因为不存在maxvalue分区。检查主键和索引: select index_name,status from user_indexes where table_name='TP2'; select index_name,partition_name,status from user_ind_partitions where index_name='IDX_TP2_C2' order by partition_name; 经检查,add partition对global和local索引均无影响,...
) PARTITIONBYRANGE(dates)INTERVAL(numtodsinterval(1,'day')) (partition part_t01valuesless than(to_date('2000-11-01','yyyy-mm-dd'))); ; --插入200万测试数据 begin for iin1..2000000loop insertintot_test_colvalues(i,sysdate-mod(i,100),'abc_aaaa','abc_bbbb','abc_cccc','abc_dddd'...
为split分区命令添加update indexes选项: ALTER TABLE tp2 SPLIT PARTITION p2 AT (8) INTO (PARTITION p2, PARTITION p28) update indexes; 检查本次split分区对global&local索引均无影响,如下图: rebuild local索引不可用的分区: alter index idx_tp2_c2 rebuild partition p1 online; alter index idx_tp2_c2 ...