Index inconsistency with interval partitions

Bug 10633840 - ORA-1502 on insert statement on INTERVAL partitioned table. ORA-8102 / ORA-1499 Index inconsistency [ID 10633840.8]

Affects:

Product (Component)	Oracle Server (Rdbms)
Range of versions believed to be affected	Versions BELOW 12.1
Versions confirmed as being affected	11.2.0.2 11.1.0.7
Platforms affected	Generic (all / most platforms affected)

Fixed:

This issue is fixed in

12.1 (Future Release) 11.2.0.3 (Server Patch Set) 11.2.0.2.7 Patch Set Update 11.2.0.2 Bundle Patch 17 for Exadata Database 11.2.0.2 Patch 20 on Windows Platforms

Symptoms:	Related To:
Corruption (Index) Error May Occur Internal Error May Occur (ORA-600) ORA-1502 / ORA-1499 / ORA-8102 ORA-600 [kdsgrp1] ORA-600 [qertbFetchByRowID]	Partitioned Tables deferred_segment_creation

Description

There is a concurrency issue with deferred segment creation and
INTERVAL partitioning which can lead to errors.
 
This issue may also cause inconsistency between the table an index causing 
errors like:
 
  ORA-8102
  ORA-600 [kdsgrp1]
  ORA-600 [qertbFetchByRowID]
  ORA-1499 by "analyze table <name> validate structure cascade"
 
Rediscovery Notes:
 ORA-1502 in tables with deferred segment creation is the most
 common symptom.
 Index / Table inconsistency causing several errors.
 
Workaround
 Force segments to be created - This is a two step process:
 
 - Disable deferred segment creation for future objects using the parameter 
   deferred_segment_creation = FALSE
 
 - Materialize segments for objects that are currently deferred.  This can be
   done using the DBMS_SPACE_ADMIN.MATERIALIZE_DEFERRED_SEGMENTS() procedure.
   This segment materialization may be targeted to a particular table 
   partition, table, schema or the entire database depending on the 
   arguments supplied.  
 
   In all cases, associated dependent objects (lobs/indexes) will be 
   materialized as well.