Re: How to Stop/Halt Materialized Views Replication?

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Tue, 20 May 2003 22:36:42 GMT
Message-ID: <3ecaadf0.3069734294@nyc.news.speakeasy.net>

or remove the job(s)
On Tue, 20 May 2003 20:09:36 +0100, "Paul Brewer" <paul_at_paul.brewers.org.uk> wrote:

>"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
>
>
>

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Tue May 20 2003 - 17:36:42 CDT