OraFAQ Forum: Replication » Pausing and Resuming of refreshing Materialised views

Home » Server Options » Replication » Pausing and Resuming of refreshing Materialised views (Oracle 11)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Pausing and Resuming of refreshing Materialised views [message #527160]

Sat, 15 October 2011 22:53

prashas_d
Messages: 66
Registered: February 2007

Member

Hi All,

We have some materialised views in our environment which refeshes after every 1 hour. In the same environment, we have some big processes and we do not want the performance of these big processes to get affected because of refreshing these materialised views.

Could you please let me know if there is a way to pause the refreshing of materialised views before running the big processes and later after the big processes are completed, then resume the refreshing of the materialised views?

One way I can think of is to drop the materialised views and create the materialised views back.

Thanks for your help in advance.

prashas_d.

Report message to a moderator