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 |
AUD-00802: name of index is limited to 22 characters
ORA-28672: UPDATE BLOCK REFERENCES may not be used on a global index
ORA-25105: RECOVERABLE option can only be used with ALTER INDEX REBUILD
SQL*Loader-00943: incorrect datafile string specified for table string partition string
IMG-00803: invalid attribute value
NNC-00001: maximum number of connections already open
ORA-13110: cannot drop topology with associated topo_geometry tables
ORA-14189: this physical attribute may not be specified for an index subpartition
PCB-00221: OCCURS DEPENDING ON clause not allowed for host variable "string"
ORA-27469: %s is not a valid string attribute
ORA-32302: object materialized views must be object ID based
ORA-13358: circle type does not contain 3 points