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.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-1002165/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002853
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
