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-39138: Insufficient privileges to load data not in your schema
ORA-00321: log string of thread string, cannot update log file header
ORA-02092: out of transaction table slots for distributed transaction
ORA-29399: user string does not have privilege to switch to consumer group string
ORA-31201: DBMS_LDAP: generic error: string
ORA-19612: datafile string not restored due to string
RMAN-06533: KEEP ... NOLOGS option is not supported when database is open
DRG-11102: assigned lexer can not operate on string language setting
IMP-00005: all allowable logon attempts failed
ORA-26045: REF column string expects string arguments; found string.
ORA-32761: Turn off Temp LOB Ref Count Feature
ORA-02479: error while translating file name for parallel load