Unique Interval Partitioned Local Index becomes invalid
Hi,
Database Version:- 11.1.0.7
The Table is Interval Partitioned by day. This has a Local Unique Index.
On one of the inserts oracle reported that the index/index partition is in unusable state.
I checked the index and all partitions were in Valid state and contained data also.
No direct path loads/No maintenance jobs were running, and the index is local so should not be marked as unusable until that particular partition was somehow involved.
Could this be caused by a parallel insert happening at the same time?
All pointers are welcome.
Thanks
Harsh
Database Version:- 11.1.0.7
The Table is Interval Partitioned by day. This has a Local Unique Index.
On one of the inserts oracle reported that the index/index partition is in unusable state.
I checked the index and all partitions were in Valid state and contained data also.
No direct path loads/No maintenance jobs were running, and the index is local so should not be marked as unusable until that particular partition was somehow involved.
Could this be caused by a parallel insert happening at the same time?
All pointers are welcome.
Thanks
Harsh
0