Is it wise to refresh materialized view before I investigate the effects of no logging options?
It kinda depends what you are trying to achieve. It's a very open ended questions. Perhaps if you add a bit more details it might help, like the purpose of the MView. What youre plans for recovery are in the case of failure. Is it a fast refresh or not. SOmething that will give me some context.
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 12 guests