Quick Search:
 
 Oracle Database Error: ORA-12008      [Return To Oracle Error Index] Jump to:  
Oracle Error: ORA-12008

Error Description:
Error in materialized view refresh path

Error 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.


There haven't been any comments added for this error yet. You may add one if you like.  Add a comment 
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org