RE: MV refresh

From: Lei Zeng <lzeng_at_yahoo-inc.com>
Date: Wed, 2 Sep 2009 22:02:02 -0700
Message-ID: <EB9DFB3B8215BD428634CD68162F55B60454C91B_at_SNV-EXVS06.ds.corp.yahoo.com>

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

Thanks,

Lei Zeng

Sr. Oracle DBA

Yahoo

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

From: oracle-l-bounce_at_freelists.org
[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.

wrote:

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

Hemant K Chitale

http://hemantoracledba.blogspot.com

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 03 2009 - 00:02:02 CDT

This message: [ Message body ]
Next message: Nuno Souto: "Re: Best practice for Dataguard in 10g?"
Previous message: Hemant K Chitale: "Re: MV refresh"
In reply to: Hemant K Chitale: "Re: MV refresh"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message