ORA-12008: error in materialized view refresh path



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

Post New Answer

More Oracle Errors Interview Questions

ORA-04053: error occurred when validating remote object stringstringstringstringstring

1 Answers  


ORA-28039: cannot validate Kerberos service ticket

1 Answers  


ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index

1 Answers  


ORA-01181: file string created before last known RESETLOGS, cannot recreate

1 Answers  


ORA-24013: invalid value string, RETRY_DELAY should be non-negative

1 Answers  






RMAN-07506: Do you really want to catalog the above files (enter YES or NO)?

1 Answers  


KUP-04070: field string referenced by column transform string not found

1 Answers  


ORA-22933: cannot change object with type or table dependents

1 Answers  


TNS-01017: set|show current_listener [<listener_name>]: sets|shows current listener

1 Answers  


ORA-06568: obsolete ICD procedure called

1 Answers  


ORA-25107: duplicate TABLESPACE option specification

1 Answers  


ORA-31635: unable to establish job resource synchronization

1 Answers  


Categories