This was already discussed in this list here //www.freelists.org/archives/oracle-l/01-2007/msg00666.html and asktom here http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:15695764787749 Gints Plivna http://www.gplivna.eu 2008/3/5, Sanjay Mishra <smishra_97@xxxxxxxxx>: > > Is it correct that upgrading from 9i to 10g will change the MV refresh > behaviour. I checked in one forum that it will use delete command for > complte refresh instead of Truncate. Has anybody seen this issue. If this is > true then Is there any parameter in init.ora that can change the default > behaiour of 9i like using Truncate. I checked the forum and they are > referring Atomic Refresh attribute in DBMS_mview can revert the process but > it is not good to modify several MV. > > Is it only true when we move from 9i to 10g or also true if MV are created > in 10g itself. -- //www.freelists.org/webpage/oracle-l