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-31424: change table has active subscriptions

1 Answers  


SQL*Loader-00525: OCI return status: success

1 Answers  


NID-00442: Database has been shutdown, open database with RESETLOGS option.

1 Answers  


ORA-30508: client logon triggers cannot have BEFORE type

1 Answers  


RMAN-08044: channel string: finished piece string at string

1 Answers  






ORA-13004: the specified buffer size is invalid

1 Answers  


NNL-00400: Response status:

1 Answers  


ORA-31012: Given XPATH expression not supported

1 Answers  


IMG-00712: unable to write to destination image

1 Answers  


TNS-00145: PUMPS value in INTCHG.ORA is too large.

1 Answers  


RMAN-05018: some datafile copies cannot be recovered, aborting the RECOVER command

1 Answers  


ORA-16147: standby database referenced by multiple archive log destinations

1 Answers  


Categories