Re: redo curiosity
From: Maureen English <maureen.english_at_alaska.edu>
Date: Thu, 18 Feb 2010 12:22:13 -0900
Message-ID: <4B7DAF85.8090408_at_alaska.edu>
Thanks! That's definitely worth a try. I'll add this to our large refreshes to see what difference it makes tonight.
Date: Thu, 18 Feb 2010 12:22:13 -0900
Message-ID: <4B7DAF85.8090408_at_alaska.edu>
Thanks! That's definitely worth a try. I'll add this to our large refreshes to see what difference it makes tonight.
- Maureen
Allen, Brandon wrote:
> The solution/workaround is to set atomic_refresh=>false so it will truncate the mview table instead of doing a delete. Just search for "atomic_refresh" on MOS and you'll see the relevant notes about this (e.g. 365157.1).
>
> Regards,
> Brandon
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 18 2010 - 15:22:13 CST