I have a query and when I run it I can insert the results fine into the table it needs to go into.
But when we run it as an MV refresh:
dbms_mview.refresh(mv, atomic_refresh => transactional) ;we get this error:
Error report -
ORA-12008: error in materialized view refresh path
ORA-01722: invalid number
ORA-06512: at "LINK_OD_IREPORT.R_MV_IN_PLACE", line 26
ORA-06512: at line 1
12008. 00000 - "error in materialized view refresh path"
*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.Does anyone know what this means? I've tried querying these and it says they don't exist: select * from $SNAPSHOT_mv_name;
select * from MVIEW$_mv_name;
4 Related questions 1 Oracle refresh materialized view - Compile error 4 Oracle refresh throws a table not found exception 1 getting Oracle materialized view to refresh Related questions 1 Oracle refresh materialized view - Compile error 4 Oracle refresh throws a table not found exception 1 getting Oracle materialized view to refresh 70 How to refresh materialized view in oracle 0 Refresh in Materialized Views 4 Refreshing an existing materialized View 0 Materialized View won't get created if I use refresh fast clause 0 ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view 2 Oracle: Materialized view refresh is not being refreshed automatically 0 Fast refresh on Materialized view giving error Load 7 more related questions Show fewer related questions Reset to default
