Big MV
From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Tue, 10 Mar 2009 08:27:24 -0700 (PDT)
Message-ID: <943544.80538.qm_at_web51309.mail.re2.yahoo.com>
Hi
Date: Tue, 10 Mar 2009 08:27:24 -0700 (PDT)
Message-ID: <943544.80538.qm_at_web51309.mail.re2.yahoo.com>
Hi
I had to create 10 MV from Source to Dest Database. Size of 10 Tables on Source is above 200G and so creating the MV over the Network will be big load on the Network as well performance/Speed will not be good. So Is there any alternate process to do this Setup. These MV will be refreshed later only once a Week.
Also Can somebody point me to good paper or send the doc to create Snapshot Group and include all MV as part of the group instead of all specifying as individual MV. What are the pros and cons of having them as individual MV vs part of Snapshot group. One of the advantage I can understand is the Dependency but if expert advice has some preference.
thanks
Sanjay
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 10 2009 - 10:27:24 CDT