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 |
TNS-00527: Protocol Adapter not loadable
ORA-09218: sfrfs: failed to refresh file size
DRG-11480: ctxkbtc memory allocation error: %(1)
ORA-07841: sllfop: SYS$OPEN failure
ORA-12537: TNS:connection closed
2 Answers State Bank Of India SBI,
ORA-27028: skgfqcre: sbtbackup returned error
TNS-00037: INTCTL: error opening Navigator or Connection Manager error files
ORA-13034: Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object
ORA-24201: duplicate publisher, publisher already added to the queue
ORA-04021: timeout occurred while waiting to lock object stringstringstringstringstring
RMAN-06565: WARNING: string: sqlcode number was caught, automatic retry #number
ORA-01301: error writing to file during flat file build