ORA-12008: error in materialized view refresh path

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

NZE-28890: Entrust Login Failed

1488


NZE-28868: Peer certificate chain check failed.

2365


ORA-26032: index string.string loading aborted after string keys

1739


When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2426


ORA-16516: The current state is invalid for the attempted operation.

8259






ORA-26095: unprocessed stream data exists

3051


ORA-26076: cannot set or reset value after direct path structure is allocated

1573


ORA-26094: stream format error: input column overflow

2353


ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2427


ORA-26084: direct path context already finished

1589


IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1324


ORA-26030: index string.string had string partitions made unusable due to:

1644


if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2327


when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

1840


IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

2733