Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Refreshing Materialized view
anish.kanti.ghosh_at_gmail.com says...
> Hi All,
> I am using a materialized view which is based on certain views. This
> views are again based on on some other views on actual tables.
> When i refresh this MV using:
>
> alter materialized view <mv_name> refresh complete;
This changes the materialized view's refresh methodology, but doesn't actually *do* the refresh.
> "snapshot altered"
> message is coming but the mv is not getting refreshed.
>
> Plz suggest why this is happening.
Try:
exec DBMS_MVIEW.REFRESH('<mv_name>', 'c');
where 'c' = complete
GM Received on Wed Nov 15 2006 - 16:15:46 CST