Oracle DBA, How To, Error, Cause and Action
ORA-12008: error in materialized view refresh path
ORA-12008: error in materialized view refresh pathCause: Table SNAP$_
reads rows from the view MVIEW$_, 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 .MLOG$_ is also referenced.
Action: Examine the other messages on the stack to find the problem. See if the objects SNAP$_, MVIEW$_, .@, .MLOG$_@ still exist.
No comments:
Post a Comment
Thanks for your comment.