Home » Server Options » Replication » Replicate table data in a specific order
Replicate table data in a specific order [message #75565] Wed, 27 October 2004 09:47 Go to next message
Navin
Messages: 31
Registered: May 2002
Member
Hi,

I have 3 tables say T1, T2, T3.  I want replication/refresh of Materialized views to happen on T1 first, followed by T2 and then T3.  All the three views are freshed by the same refresh group. 

I can create a few refresh groups and schedule their refresh at different intervals, but we do not want this,as the first refresh if takes a while to fresh T1, data will not be consistent....

So in A fresh group, can we force the refresh to happen on T1, then T2 and finally on T3 materialized views.

Thank you so much in advance.
Rachna
Re: Replicate table data in a specific order [message #75566 is a reply to message #75565] Wed, 27 October 2004 10:42 Go to previous message
Navin
Messages: 31
Registered: May 2002
Member
Hi,
I create a procedure like this

create or replace procedure proc_refresh100 is

begin

dbms_mview.refresh('t1,'c');
dbms_mview.refresh('t2,'c');
dbms_mview.refresh('t3,'c');

end;
/

and scheduled it to run at regular interval.

Rachna.
Previous Topic: Multimaster Replication
Next Topic: Foreign key in a table of diffrent database
Goto Forum:
  


Current Time: Thu Mar 28 04:21:14 CDT 2024