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-02349: invalid user-defined type - type is incomplete

1 Answers  


ORA-24130: table string does not exist

1 Answers  


ORA-32733: Error occurred when executing Parallel Oradebug

1 Answers  


ORA-14306: List value 'string' specified twice in partitions 'string', 'string'

1 Answers  


RMAN-03036: Debugging set to level=number, types=string

1 Answers  






ORA-39036: invalid metadata filter name string

1 Answers  


NNL-00212: Cache checkpointing is now disabled

1 Answers  


ORA-16525: the Data Guard broker is not yet available

2 Answers  


ORA-38951: Target platform string not cross platform compliant

1 Answers  


TNS-00091: * Navigator (or navgatr) - will ask the Navigator only

1 Answers  


NNL-01057: Foreign data items cached: number

1 Answers  


ORA-12653: Authentication control function failed

1 Answers  


Categories