All Oracle Error CodesOracle DBA Forum

ORA-12008:

error in materialized view refresh path
Cause: Table SNAP$_<mview_name> reads rows from the view MVIEW$_<mview_name>, which is a view on the master table (the master may be at a remote site). Any error in this path will cause this error at refresh time. For fast refreshes, the table <master_owner>.MLOG$_<master> is also referenced.
Action: Examine the other messages on the stack to find the problem. See if the objects SNAP$_<mview_name>, MVIEW$_<mview_name>, <mowner>.<master>@<dblink>, <mowner>.MLOG$_<master>@<dblink> still exist.
 SubjectReplies
1.very odd problem....oracle support has been no ...2
2.MVIEW on-demand refresh - rollback space issue2
3.very odd problem....oracle support has been no ...1
4.very odd problem....oracle support has been no ...1
5.very odd problem....oracle support has been no ...1
6.errors from alert.log1
7.anyone awake out there...ORA-00600: .....any id...1