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-30178: duplicate flag used in a format specification

1 Answers  


TNS-00209: Tracing : string

1 Answers  


IMP-00009: abnormal end of export file

1 Answers  


NNL-00272: Removed name "string" from caches along the following path:

1 Answers  


PCC-00112: Datatype not supported by ANSI

1 Answers  


ORA-16117: processing

1 Answers  


DRG-11827: Request Timeout

1 Answers  


ORA-14023: creation of GLOBAL partitioned cluster indices is not supported

1 Answers  


ORA-03113: end-of-file on communication channel

1 Answers  


ORA-01655: unable to extend cluster string.string by string in tablespace string

1 Answers  


ORA-38103: Invalid column in the UPDATE SET Clause: string

1 Answers  


RMAN-06109: changed archive log unavailable

1 Answers  


Categories