Re: Managing materialized views

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Fri, 18 Oct 2002 05:49:44 -0500
Message-ID: <uqvpq7nsbh5hd1@corp.supernews.com>

Your can use dbms_job.broken to 'break' the job. exec dbms_job.broken(10,true);

The later use it to unset the broken flag. exec dbms_job.broken(10,false);

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

Author of: 'So You Want to be an Oracle DBA?'

"Ray Teale" <ray_at_BLAHholly.com.au> wrote in message news:VfLr9.16806$Sr6.538207_at_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 Fri Oct 18 2002 - 05:49:44 CDT