Re: Refreshing Materialized view

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Wed, 15 Nov 2006 10:55:37 +0100
Message-ID: <455ae488$0$18845$9b4e6d93@newsspool4.arcor-online.net>

anish schrieb:
> 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;
>
> "snapshot altered"
> message is coming but the mv is not getting refreshed.
>
> Plz suggest why this is happening.
>
> Thanks and Regards,
>

You don't refresh your materialized view using >alter materialized view <mv_name> refresh complete; you change the refresh type of materialized view to "complete".

To actually refresh i would try instead either http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_mview.htm#sthref4924 or
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14227/rarrefreshpac.htm#i94176

Best regards

Maxim Received on Wed Nov 15 2006 - 03:55:37 CST