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-04053: error occurred when validating remote object stringstringstringstringstring
ORA-28039: cannot validate Kerberos service ticket
ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index
ORA-01181: file string created before last known RESETLOGS, cannot recreate
ORA-24013: invalid value string, RETRY_DELAY should be non-negative
RMAN-07506: Do you really want to catalog the above files (enter YES or NO)?
KUP-04070: field string referenced by column transform string not found
ORA-22933: cannot change object with type or table dependents
TNS-01017: set|show current_listener [<listener_name>]: sets|shows current listener
ORA-06568: obsolete ICD procedure called
ORA-25107: duplicate TABLESPACE option specification
ORA-31635: unable to establish job resource synchronization