ORA-08102: index key not found, obj# 1634285, file 10, block 3605911 (2)
We are on Oracle Database 11g Enterprise Edition Release 11.1.0.7.0, while trying to refresh a materialzed view, we are encountering this problem, its pertaining to index:
ORA-12012: error on auto execute of job 1589308
ORA-12008: error in materialized view refresh path
ORA-08102: index key not found, obj# 1634285, file 10, block 3605911 (2)
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2545
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2751
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2720
ORA-06512: at line 6
I have tried dropping and recreating Index but no luck. Can someone suggest the resolution for it ?
Thanks,
Kiran.