Re: dbms_refresh

  • From: Alisher Yuldashev <yuldashev@xxxxxxxxxxx>
  • To: Chuck.Boddy@xxxxxxxxxxxxxxx
  • Date: Wed, 13 Oct 2010 13:13:30 -0400

 Hi Chuck,

The order of the mview refresh is set in "list | tab" parameter of DBMS_REFRESH.MAKE procedure. Not sure if the order matters though. All mviews in the group are refreshed together to a transactionally consistent point in time.

Thanks,

Alisher Yuldashev
Senior Oracle DBA
www.pythian.com

On 10/13/2010 12:40 PM, Chuck Boddy wrote:
Hi,
Can you change the order in which a materialized view is refreshed in a refresh group?
Thanks,
Chuck

Other related posts: