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 |
LSX-00149: duplicated ID specified in "~S"
IMG-00846: adjacency matrix allocation failed
PROC-00020: ORACLE_HOME environment not set
LPX-00400: an internal error has occurred in XPATH
ORA-26566: Couldn't open connect to string
DRG-12515: cannot specify language for stopwords in a BASIC_STOPLIST
RMAN-20005: target database name is ambiguous
ORA-19690: backup piece release string incompatible with Oracle release string
ORA-28504: ROWID not found in ROWID cache for heterogeneous database link
ORA-12661: Protocol authentication to be used
ORA-02026: missing LINK keyword
TNS-00210: Total Pumps Available : number