range partitioned 和 Hash Partitioned.
Global Partitioned Indexes
Oracle offers two types of global partitioned index: range partitioned and hash partitioned.
（1）Global Range Partitioned Indexes
Global range partitioned indexes are flexible in that the degree of partitioning and the partitioning key are independent from the table's partitioning method. They are commonly used for OLTP environments and offer efficient access to any individual record.
The highest partition of a global index must have a partition bound, all of whose values are MAXVALUE. This ensures that all rows in the underlying table can be represented in the index. Global prefixed indexes can be unique or nonunique.
You cannot add a partition to a global index because the highest partition always has a partition bound of MAXVALUE. If you wish to add a new highest partition, use the ALTER INDEX SPLIT PARTITION statement. If a global index partition is empty, you can explicitly drop it by issuing the ALTER INDEX DROP PARTITION statement. If a global index partition contains data, dropping the partition causes the next highest partition to be marked unusable. You cannot drop the highest partition in a global index.
（2）Global Hash Partitioned Indexes
Global hash partitioned indexes improve performance by spreading out contention when the index is monotonically growing. In other words, most of the index insertions occur only on the right edge of an index.
（3）Maintenance of Global Partitioned Indexes
By default, the following operations on partitions on a heap-organized table mark all global indexes as unusable:
DROP EXCHANGE MERGE MOVE SPLIT TRUNCATE
sql> create index ix_custaddr_ global_id on custaddr(id) global;
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12961536/viewspace-769486/，如需转载，请注明出处，否则将追究法律责任。