RE: MV refresh

From: Lei Zeng <>
Date: Wed, 2 Sep 2009 22:02:02 -0700
Message-ID: <>

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  


Lei Zeng

Sr. Oracle DBA


-----Original Message-----

[] On Behalf Of Hemant K Chitale Sent: Wednesday, September 02, 2009 6:42 PM To:
Cc:; Subject: Re: MV refresh    

Actually, it is the other way round. The default in 10g is DELETE and INSERT.      

  • wrote:

A complete refresh in 10g does a truncate and insert append.    

Hemant K Chitale


-- Received on Thu Sep 03 2009 - 00:02:02 CDT

Original text of this message