分区操作

Modify Partition Unusable local indexes
 Marks the local index partition associated with the table partition as UNUSABLE
 
Modify Partition Rebuild Unusable local indexes
 Rebuilds the local index partitions that are marked UNUSABLE and are associated with this table partition
 
Add Partition
 Adds a new table partition. Also adds a new local index partition.
 
Drop Partition
 Drops a base table partition. Also drops the associated local index partition
 
Truncate Partition
 Truncate the table partition. Also truncates the associated local index partition
 
Move Partition
 Moves the base table partition to another tablespace. Corresponding local index partitions are marked UNUSABLE.
 
Split Partition
 Splits a table partition into two partitions. Corresponding local index partition is also split. If the resulting partitions are non-empty, the index partitions are marked UNUSABLE.
 
Merge Partition
 Merges two table partitions into one partition. Corresponding local index partitions should also merge. If the resulting partition contains data, the index partition is marked UNUSABLE.
 
Exchange Partition Excluding Indexes
 Exchanges a table partition with a non-partitioned table. Local index partitions and global indexes are marked UNUSABLE.
 
Exchange Partition Including Indexes
 Exchanges a table partition with a non-partitioned table. Local index partition is exchanged with global index on the non-partitioned table. Index partitions remain USABLE.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22308399/viewspace-750704/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22308399/viewspace-750704/