ORA-12008: error in materialized view refresh path
Answer / guest
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.
Please add more information about this Error
Is This Answer Correct ? | 0 Yes | 3 No |
ORA-19002: Missing XMLSchema URL
ORA-27016: skgfcls: sbtinfo returned error
ORA-14626: values being added already exist in DEFAULT subpartition
DRG-11111: value of string must be between string and string
ORA-04051: user string cannot use database link string.string
RMAN-08023: channel string: restored backup piece string
ORA-28164: REVOKE already specified
NNL-00303: Server checking for reload
ORA-30452: cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)
PLS-00605: set operators are not yet supported as an argument to a MULTISET operator
PLS-00211: CASE labels or ranges must not be duplicated in different WHEN clauses
QSM-02099: mv references a remote table or view in the FROM list