Partition index solution.

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.