ORA-12008
error in materialized view or zonemap 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.
ORA-12008
error in materialized view or zonemap 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.
ORA-12008
error in materialized view or zonemap 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.
