This forum is currently locked. You can't register or post questions at this time. (read more)

Is it wise to refresh materialized view before I investigate

All posts relating to Oracle database administration.

Moderator: Tim...

kytemaniac
Senior Member
Posts: 234
Joined: Tue May 19, 2009 12:59 am

Is it wise to refresh materialized view before I investigate

Postby kytemaniac » Wed Mar 27, 2013 1:15 am

Hi all,

Is it wise to refresh materialized view before I investigate the effects of no logging options?

thanks

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Is it wise to refresh materialized view before I investi

Postby Tim... » Wed Mar 27, 2013 7:20 am

Hi.

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. :)

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
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


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 0 guests

cron