split分区表，全局索引失效问题

wxlun

操作系统：linux red hat 5.6 x64
数据库版本：oracle 11.2.0.3

有一个表含有 partition M_OTHER values less than (MAXVALUE)范围分区，M_OTHER有数据，而且有全局索引， 需要做split操作对表增加分区，增加前做测试发现：

语句类似：
alter table M_OTHER split partition M_OTHER at (TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS')) into (partition M_201311 tablespace tbs_, partition M_OTHER);

如果M_OTHER 分区的全部数据split到M_201307，或者没有数据到M_201307，全局索引不失效，如果部分数据进去到M_201307，则全局索引失效。

请问：为什么部分数据进去到新分区，全局索引会失效，它们之间的区别在哪儿？

harryzhang

Maintenance of Global Partitioned Indexes
By default, the following operations on partitions on a heap-organized table mark all global indexes as unusable:

ADD (HASH)
COALESCE (HASH)
DROP
EXCHANGE
MERGE
MOVE
SPLIT
TRUNCATE


These indexes can be maintained by appending the clause  UPDATE INDEXES to the
SQL statements for the operation. The two advantages to maintaining global indexes:

■ The index remains available and online throughout the operation. Hence no other applications are affected by this operation.
■ The index doesn't have to be rebuilt after the operation.


Example:  ALTER TABLE DROP PARTITION P1 UPDATE INDEXES;

wxlun

能提供一下，做split操作，oracle 底层做了什么吗，怀疑有数据move导致部分数据进去到新分区，全局索引会失效，而其他两种情况为修改数据字典，不知道对不对