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.
分享到:
相关推荐
partition by 使用说明
上传oracle数据库文档 主要讲解oracle分区和索引 提高数据库性能的
本文介绍如何通过添加Informatica partition进行Session调优,包括判断Session瓶颈,选择partition类型
说到这里,大家首先想到的工具八成是PQMagic,不过在这里我给大家介绍的是Paragon公司的Partition Manager 7.0。之所以介绍它,是因为这个工具比PQMagic对中文操作系统的支持要好的多,安全系数比较高,功能也丝毫不...
Partition Bad Disk(硬盘坏道扇区修复工具) 绿色破解版是一款非常优秀的可以帮助你将硬盘中的坏道扇区自动的彻底扫描检测出来,然后隐藏隔离起来的磁盘工具软件,使得新创建的分区可以不受坏道扇区的影响!...
Paragon Partition Manager 是一套磁盘管理软件,是目前为止最好用的磁盘管理工具之一,能够优化磁盘使应用程序和系统速度变得更快,不损失磁盘数据下调整分区大小,对磁盘进行分区,并可以在不同的分区以及分区之间...
ORACLE数据库中PARTITION的用法[文].pdf
Paragon Partition Manager 11
Oracle Partition分区详细总结.pdf
As Partition Magic alternative, EASEUS Partition Master freeware is an ALL-IN-ONE partition software and the most convenient hard disk partition manager toolkit including Partition Manager, Disk & ...
主要介绍了Oracle查询中OVER (PARTITION BY ..)用法,内容和代码大家参考一下。
partition
基于partition的连接算法
Active@ Partition Recovery for Windows - will help you if non-system partition is lost, i.e. you can boot Windows, install and run the software from under Windows to recover deleted or damaged ...
什么是EASEUS Partition Master 如果你买了一台新的只有一个分区的电脑,或者当我们使用一段日子发现之前的分区不能满足自己的需要时,我们最需要的就是一款可以支持XP、Vista等系统的无损分区软件了。有一款分区...
Powerquest Partition Magic后被norton收购改叫Norton Partition Magic,最新版8.05有5年没更新。 而 Paragon Partition Manager 公司名是 Paragon。版本更新比较块,各个WinPE系统里面基本有它的7.0 Server版,不过...
Recovery Partition Creator 4.0.4 is used to recreate the "Recovery Partition" of macOS system on MBP,iMac and Mac Mini etc. It is compatible with the macOS10.9 or greater. It can work on the last ...
Python partition函数的基本应用。partition函数主要用于拆分字符串。
Recovery Partition Creator 4.0.4 is used to recreate the "Recovery Partition" of macOS system on MBP,iMac and Mac Mini etc. It is compatible with the macOS10.9 or greater. It can work on the last ...
深入探讨oracle partition的机制与实现