RE: MV refresh
Date: Wed, 2 Sep 2009 22:02:02 -0700
Check out this metalink note
553464.1 Complete Refresh Read Consistency Behavior During Refresh and Complete Refresh Performance as Influenced by the ATOMIC_REFRESH Refresh Parameter
Sr. Oracle DBA
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hemant K Chitale Sent: Wednesday, September 02, 2009 6:42 PM To: tomdaytwo_at_gmail.com
Cc: wellmetus_at_gmail.com; oracle-l_at_freelists.org Subject: Re: MV refresh
Actually, it is the other way round. The default in 10g is DELETE and INSERT.
A complete refresh in 10g does a truncate and insert append.
Hemant K Chitale
http://www.freelists.org/webpage/oracle-l Received on Thu Sep 03 2009 - 00:02:02 CDT