Re: How to Stop/Halt Materialized Views Replication?

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Tue, 20 May 2003 20:09:36 +0100
Message-ID: <3eca80e6_1@mk-nntp-1.news.uk.worldonline.com>

"Rob Cowell" <rjc4687_at_hotmail.com> wrote in message news:3EC9FDC7.165BA479_at_hotmail.com...
>
>
> weeang wrote:
> >
> > Hi,
> >
> > Is it possible to stop/halt materialized views replication without
> > deleting the materialized views itself? How can I stop it?
> >
> > My servers environment are:
> > Master : IBM AIX, with Oracle 9.0.1
> > Replication : HP-UX, with Oracle 8.1.6
> >
> > Please help!
> >
> > Thanks n Brgds,
> > weeang
>
> ALTER the materialized view so that it refreshes ON DEMAND. Then don't
> demand it.

Or set job_queue_processes=0 - unless you have other jobs you still want to run.

Or break the job(s).

Or set next_date in the far future....

Regards,
Paul Received on Tue May 20 2003 - 14:09:36 CDT