Partition index solution

iteye_2139

于 2011-09-19 14:41:29 发布

阅读量114

点赞数

CC 4.0 BY-SA版权

分类专栏： Database 文章标签： Partition Index

本文链接：https://blog.youkuaiyun.com/iteye_2139/article/details/82139773

Database 专栏收录该内容

3 篇文章

订阅专栏

本文详细解释了六种可能导致数据库索引分区变为INDEXUNUSABLE状态的维护操作，包括导入分区、常规路径SQL*Loader、直接路径SQL*Loader、分区维护操作如移动分区、截断分区、分裂分区，以及索引维护操作如分裂分区。这些操作可能需要重建索引分区来恢复正常。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

There are six types of maintenance operations that mark index partitions INDEX

UNUSABLE (IU). Solution Explanation:

Maintenance operations causing index partitions to become INDEX UNUSABLE (IU):

1. IMPORT PARTITION or conventional path SQL*Loader.

2. Direct-path SQL*Loader leaves affected local index partitions and

global indexes in an IU state if it does not complete successfully.

3. Partition maintenance operations like ALTER TABLE MOVE PARTITION.

4. Partition maintenance operations like ALTER TABLE TRUNCATE PARTITION.

5. Partition maintenance operations like ALTER TABLE SPLIT PARTITION.

6. Index maintenance operations like ALTER INDEX SPLIT PARTITION.

Each of these operations may cause index partitions to be marked IU which will

require the index partitions to be rebuilt.