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 -> Refreshing Materialized view

Refreshing Materialized view

From: anish <anish.kanti.ghosh_at_gmail.com>
Date: 15 Nov 2006 01:25:16 -0800
Message-ID: <1163582716.400572.53960@f16g2000cwb.googlegroups.com> 





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,
Received on Wed Nov 15 2006 - 03:25:16 CST












Original text of this message













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