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-01230: cannot make read only - file string is offline
ORA-06401: NETCMN: invalid driver designator
ORA-24419: Proxy sessions are not supported in this mode.
ORA-13454: GeoRaster metadata is invalid
TNS-03603: Encountered a node with a version eariler than SQL*Net 2.3
DRG-11857: Server Timed Out
QSM-01129: query has NO_MULTIMV_REWRITE hint
ORA-12593: TNS:no registered connection
ORA-19684: block media recovery failed because database is suspended
ORA-12082: "string"."string" cannot be index organized
DRG-12408: invalid variable reference: string.string
NNF-00002: Invalid value passed to function call