Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Refreshing Materialized view

Re: Refreshing Materialized view

From: Geoff Muldoon <geoff.muldoon_at_trap.gmail.com>
Date: Thu, 16 Nov 2006 09:15:46 +1100
Message-ID: <MPG.1fc63c9994ef3915989898@news.readfreenews.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US