Re: Replication problem

From: Bing Wu <bing_at_biop.ox.ac.uk>
Date: Mon, 13 Jun 2005 15:08:49 +0100
Message-ID: <d8k41h$694$1@news.ox.ac.uk>

Thanks for your comments. tried this on the slave node:

• resume materialized view on slave node

DECLARE number_of_failures INTEGER;
BEGIN

     dbms_mview.REFRESH_ALL_MVIEWS(number_of_failures,'F',null,true,false);
     dbms_output.put_line('number_of_failures = ' || number_of_failures);

END;
/

It seems nothing happened over to the master node. Any suggestion?

Many thanks,

Bing

Maxim Demenko wrote:
> Bing Wu schrieb:
>

>> Frank van Bortel wrote:
>>
>>>> BTW, is anyone know how to resume
>>>> the replication process on the slave node as I don't want to drop and
>>>> recreate the replicated views?
>>>
>>>
>>>
>>>
>>> dbms_refresh.refresh, I presume. The same way it runs now
>>>
>> Thanks. dbms_refresh.refresh is for refreshing a group of views so how 
>> do I refresh individual or all views?
>>
>> Thanks,
>>
>> Bing

>
> http://download-west.oracle.com/docs/cd/B14117_01/appdev.101/b10802/d_mview.htm#997198
>
>
> Best regards
>
> Maxim
Received on Mon Jun 13 2005 - 09:08:49 CDT