Re: Oracle 9i vs 10g MV refresh behaviour
Date: Wed, 5 Mar 2008 23:03:49 +0200
Message-ID: <6e49b6d00803051303x27bed368k40ce0db53b8a3837@mail.gmail.com>
This was already discussed in this list here
http://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_at_yahoo.com>:
>
> 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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 05 2008 - 15:03:49 CST