Hi,
we are getting an ORA-08102 error from a function based secondary index on an index organized table. We see this on both oracle 11.2.0.4 and 12.1.0.2 (info added after Jonathans comment).
We were able to swap the order of some columns and this made the problem seem to disappear. However, we are uncertain if this bug may reappear under different circumstances later.
We opened an SR with oracle but thought we would also put the question out here in the hope that someone has seen this or something similar before and knows the reason why?
Attached is a complete example of two table layouts, one that works and one that does not. After the corruption occurs, we can see that the values in the index were not updated by the update statement in the example. The output when it fails is:
...
DELETE FROM x WHERE A = 1 AND C = 1 AND E = -33 AND M = 0 AND N = 2 AND Q = -5 AND R = 1
*
ERROR at line 1:
ORA-08102: index key not found, obj# 103729, file 5, block 104594 (2)
this gave ORA-08102, now see index data
From FBIX
P COUNT(*)
---------- ----------
200 1
From PK/Table
P COUNT(*)
---------- ----------
201 1
Notice the difference.
Rollback complete.
Thanks in advance for any hints, help, similar experiences etc. you may be able to share.