Database Administration (MOSC)

MOSC Banner

ORA-08102: index key not found, obj# 1634285, file 10, block 3605911 (2)

edited Jun 26, 2018 10:15AM in Database Administration (MOSC) 3 commentsAnswered
Hi All,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center