Re: Managing materialized views

Or change the dbms_job schedule to a weekly or twice weekly. Check the 8i Replication Docs for more info

Jim

"Steve Ashmore" <sashmore_at_neonramp.com> wrote in message news:uqvpq7nsbh5hd1_at_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 Mon Oct 21 2002 - 22:02:11 CDT