分区交换及分区索引重建

create index ind_l_object_id on test(object_id) local ;

--分区交换：PART_OWNER9 数据与  bk_test 表互换 ；UPDATE GLOBAL INDEXES ：保证原来的索引还有效
alter table test exchange partition PART_OWNER9  with table bk_test UPDATE GLOBAL INDEXES;


--非分区索引重建
alter index ind_l_object_id rebuild online NOLOGGING;


--分区索引重建
Alter index ind_l_object_id rebuild partition PART_OTHER online; 
Alter index ind_l_object_id rebuild partition PART_OWNER1 online; 
Alter index ind_l_object_id rebuild partition PART_OWNER2 online; 
Alter index ind_l_object_id rebuild partition PART_OWNER3 online; 
Alter index ind_l_object_id rebuild partition PART_OWNER4 online; 
Alter index ind_l_object_id rebuild partition PART_OWNER5 online; 
Alter index ind_l_object_id rebuild partition PART_OWNER6 online; 
Alter index ind_l_object_id rebuild partition PART_OWNER7 online; 
Alter index ind_l_object_id rebuild partition PART_OWNER8 online; 
Alter index ind_l_object_id rebuild partition PART_OWNER9 online; 
Alter index ind_l_object_id rebuild partition PART_OWNER10 online;