I would like to share my problem today I have faced.

I have two databases : one is 10.1.0.2.0 and 2nd is 9.2.07.

I have run query from SQL plus to sum of AMT column then from both database i got same result.

But when i run report (Reports 6i) from both databases, i got different result set. No error found during error.

After that I have tried to rebuild indexes.

On 9.2.0.7 has given me error regarding duplicate value while rebulding primary key index.

So I found the duplicate value from my table and tried to delete then I got following error.

ORA-08102: index key not found, obj# 32394, dba 54633325 (2).

So i have create the another table from old one, drop old one and recreate.

So due to corruption I got different result set on database.