ORA-12008: error in materialized view refresh path
Cause: Table SNAP$_lamp;lt;lamp;nbsp;mview_namelamp;gt; reads rows from the view MVIEW$_ lamp;lt;lamp;nbsp;mview_namelamp;gt;, 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 lamp;lt;lamp;nbsp;master_ownerlamp;gt;.MLOG$_lamp;lt;lamp;nbsp;masterlamp;gt; is also referenced.
Action: Examine the other messages on the stack to find the problem. See if the objects SNAP$_lamp;lt;lamp;nbsp;mview_namelamp;gt;, MVIEW$_lamp;lt;lamp;nbsp;mview_namelamp;gt;, lamp;lt;lamp;nbsp;mownerlamp;gt;.lamp;lt;lamp;nbsp;masterlamp;gt;lamp;lt;lamp;nbsp;dblinklamp;gt;, lamp;lt;lamp;nbsp;mownerlamp;gt;.MLOG$_lamp;lt;lamp;nbsp;masterlamp;gt;lamp;lt;lamp;nbsp;dblinklamp;gt; still exist.
Cause: Table SNAP$_lamp;lt;lamp;nbsp;mview_namelamp;gt; reads rows from the view MVIEW$_ lamp;lt;lamp;nbsp;mview_namelamp;gt;, 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 lamp;lt;lamp;nbsp;master_ownerlamp;gt;.MLOG$_lamp;lt;lamp;nbsp;masterlamp;gt; is also referenced.
Action: Examine the other messages on the stack to find the problem. See if the objects SNAP$_lamp;lt;lamp;nbsp;mview_namelamp;gt;, MVIEW$_lamp;lt;lamp;nbsp;mview_namelamp;gt;, lamp;lt;lamp;nbsp;mownerlamp;gt;.lamp;lt;lamp;nbsp;masterlamp;gt;lamp;lt;lamp;nbsp;dblinklamp;gt;, lamp;lt;lamp;nbsp;mownerlamp;gt;.MLOG$_lamp;lt;lamp;nbsp;masterlamp;gt;lamp;lt;lamp;nbsp;dblinklamp;gt; still exist.
No comments:
Post a Comment