ORA-12008: error in materialized view refresh path



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

Post New Answer

More Oracle Errors Interview Questions

ORA-19002: Missing XMLSchema URL

1 Answers  


ORA-27016: skgfcls: sbtinfo returned error

1 Answers  


ORA-14626: values being added already exist in DEFAULT subpartition

1 Answers  


DRG-11111: value of string must be between string and string

1 Answers  


ORA-04051: user string cannot use database link string.string

1 Answers  






RMAN-08023: channel string: restored backup piece string

1 Answers  


ORA-28164: REVOKE already specified

1 Answers  


NNL-00303: Server checking for reload

1 Answers  


ORA-30452: cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)

1 Answers  


PLS-00605: set operators are not yet supported as an argument to a MULTISET operator

1 Answers  


PLS-00211: CASE labels or ranges must not be duplicated in different WHEN clauses

1 Answers  


QSM-02099: mv references a remote table or view in the FROM list

1 Answers  


Categories