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