Re: materialized view
- From: Kar <kp0773@xxxxxxxxx>
- To: Thomas Roach <troach@xxxxxxxxx>
- Date: Thu, 3 Dec 2009 22:01:38 -0800
we are holding on it and still looking for any quick option otherwise
we are planning to do FAST refresh.
On Thu, Dec 3, 2009 at 9:58 PM, Thomas Roach <troach@xxxxxxxxx> wrote:
> How are you performing the complete refresh? Is it scheduled?
>
>
> On Thu, Dec 3, 2009 at 10:59 PM, Kar <kp0773@xxxxxxxxx> wrote:
>
>> All,
>>
>> 10.2.0.4 - Solaris
>> dropping and recreating a MV takes 10 minutes. but while doing a complete
>> refresh it takes 8 hour. would appreciate any tips before I think of
>> converting it to a fast refresh ..
>>
>> thanks in advance.
>>
>> Kar
>>
>
>
>
> --
> Thomas Roach
> 813-404-6066
> troach@xxxxxxxxx
>
Other related posts:
