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-14264: table is not partitioned by Composite Range method

1 Answers  


ORA-29519: name string resolved via a synonym in schema string to a class with a different name

1 Answers  


ORA-00264: no recovery required

1 Answers  


ORA-38489: predicate table creation failed due to: ORAstring

1 Answers  


TNS-12569: TNS:packet checksum failure

1 Answers  


ORA-07657: slsprom:$ASSIGN failure

1 Answers  


RMAN-07509: List of Cataloged Files

1 Answers  


PLS-00621: at least one operand in the COALESCE expression must not be NULL

1 Answers  


ORA-12447: policy role already exists for policy string

1 Answers  


ORA-23478: object group "string" is already mastered at string

1 Answers  


ORA-23458: inappropriate flavor string at string

1 Answers  


PCC-00036: No input file name specified

1 Answers  


Categories