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-12981: cannot drop column from an object type table

1 Answers  


PLS-00256: %s is not a valid external library

1 Answers  


ORA-04940: unsupported optimization of Oracle binary, check alert log for more info

1 Answers  


PCC-01511: Identifier on line number in file string too long for code generated in file string

1 Answers  


ORA-36610: (XSLMS00) Unable to locate a message file for product 'value' and facility 'value'.

1 Answers  






RMAN-06450: crosschecked proxy copy: found to be 'string'

1 Answers  


ORA-03129: the next piece to be inserted is required

1 Answers  


NID-00503: DBNAME New database name (NONE)

1 Answers  


NNL-00346: Save_config_on_stop is now ON

1 Answers  


ORA-16171: RECOVER...FINISH not allowed due to gap for thr string, seq string-string

1 Answers  


ORA-16796: One or more properties could not be imported from the database.

2 Answers  


ORA-09340: Specified ORACLE_SID is either invalid or too long

1 Answers  


Categories