Database DataWarehousing (MOSC)

MOSC Banner

materialized view error

edited Jan 14, 2010 1:01AM in Database DataWarehousing (MOSC) 4 comments
I'm create a materialized view and join in a refresh  group.

the mview use fast refresh, but often error.  the error is : 

ORA-12012: error on auto execute of job 41
ORA-12008: error in materialized view refresh path
ORA-08102: index key not found, obj# 55209, file 8, block 481 (2)
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1

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