Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Urgent - Replication

Urgent - Replication

From: Suganya <ukumsu02_at_shafika.vetri.com>
Date: Tue, 23 Jan 2001 18:31:44 +0530
Message-Id: <10750.127265@fatcity.com>


Hi all

HO Master defanation site
Factory1 Master site
Factory2 Master site
Depot1 Master site
Depot2 Master site
Depot3 Master site
Depot4 Master site

HO and Factory1 were under replication environment now. Factory1 is pushing all rows from the Table B to HO.

Critical area :
Factory1 has to push the selected rows from Table B to Depot1.
(Selected rows -> select * from Table B where B.Depot = Depot1 and B.Trn_Type
= 'ISSUES' )
(Same logic as above for all the other respective Depots)

At Depot1 on Table B.

Business Logic - Pushed 'ISSUES' data are retrieved through ERP and

        are changed as 'RECEIPTS' with some Excise validation and
        Excise updation and this 'RECEIPTS' changes should not be
        replicated to other sites.


When going to include Factory2 the same situation will occure
for all the 3 depots. Also factory1 data should not be replicated to factory2 and vise versa.

   Is it possible through advanced replication if so please give me some clues immediately.
It is pretty urgent Received on Tue Jan 23 2001 - 07:01:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US