OraFAQ Forum: Replication » Replicate table data in a specific order

Home » Server Options » Replication » Replicate table data in a specific order

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Replicate table data in a specific order [message #75565]

Wed, 27 October 2004 09:47

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

Report message to a moderator

Re: Replicate table data in a specific order [message #75566 is a reply to message #75565]

Wed, 27 October 2004 10:42

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.

Report message to a moderator

Previous Topic:	Multimaster Replication
Next Topic:	Foreign key in a table of diffrent database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 14:16:09 CST 2025