Paul Brewer 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
>
>
>
There's a call for that in the repcat packages.
It will render the replication 'quisced'. Once restarted
all data will propagate
--
Regards, Frank van Bortel
Received on Thu May 22 2003 - 14:34:44 CDT
