Re: materialized view

From: Kar <kp0773_at_gmail.com>
Date: Thu, 3 Dec 2009 22:01:38 -0800
Message-ID: <39a33df90912032201j261b551co58c96c7899f2a055_at_mail.gmail.com>

  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_at_gmail.com> wrote:

> How are you performing the complete refresh? Is it scheduled?
>
>
> On Thu, Dec 3, 2009 at 10:59 PM, Kar <kp0773_at_gmail.com> 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_at_gmail.com
>

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

Received on Fri Dec 04 2009 - 00:01:38 CST