Managing materialized views

From: Ray Teale <ray_at_BLAHholly.com.au>
Date: Fri, 18 Oct 2002 13:33:17 +1000
Message-ID: <VfLr9.16806$Sr6.538207@ozemail.com.au>

Oracle 8.1.7 - Solaris

Just a quick question.

I have several simple snapshots replicating from tables on various remote databases. The snapshots are doing fast refreshes. I know that one of the remote machines will have no activity for a week and therefore the refresh is not required.

The qustion is - What is the conventional way of disabling the snapshot refresh for this machine? It is not immediately obvious, to me, from the "Alter Snapshot" command documentation.
Should I remove the job from the queue explictily, or is there a better way? Can I "disable" the snapshot?

I still wish to keep the snapshot and would like to enable the refresh again in a week or so.

Thanks for your help.

Regards

Ray Received on Thu Oct 17 2002 - 22:33:17 CDT