Re: materialized view

From: Thomas Roach <troach_at_gmail.com>
Date: Fri, 4 Dec 2009 00:58:10 -0500
Message-ID: <b86ffce60912032158t3f473c25q7fdc95344c656c85_at_mail.gmail.com>

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 Thu Dec 03 2009 - 23:58:10 CST