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 |
PCB-00008: Must use option SQLCHECK=SEMANTICS(FULL) when there is embedded PL/SQL
PLS-01507: DROP is non-ANSI
QSM-02137: agg(expr) requires correspondng STDDEV(expr) function
ORA-02270: no matching unique or primary key for this column-list
ORA-01083: value of parameter "string" is inconsistent with that of other instances
ORA-02735: osnfpm: cannot create shared memory segment
NID-00353: string
ORA-26091: requested direct path operation not supported
DRG-11810: Partial Update OK
NNO-00611: disabling request forwarding
ORA-27208: syntax error in device PARMS - environment variable value missing
ORA-13456: GeoRaster cell data error