Re: materialized view
Date: Fri, 4 Dec 2009 00:58:10 -0500
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:
> 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.
-- Thomas Roach 813-404-6066 troach_at_gmail.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 03 2009 - 23:58:10 CST