Trigger on destination database
edited Dec 11, 2013 7:00PM in GoldenGate, Streams and Distributed Database (MOSC) 15 commentsAnswered ✓
Hi,I will be using goldengate 12.1 to configure active active replication on my 11.2.0.3 databases. I am concerned about triggers on destination site.
I have a table1 on which i have trigger1 which fires on insert of table1 and inserts some value in table2. If I replicate table1, table2 and trigger1 on site to using golden gate, what will happen on site 2 when a row will be inserted in table 1.
Source
1) insert a row in table1
2) trigegr1 fires and inserts in table2
3) data is replicated on site 2
4) row is inserted in table1 on site2 (will it fire trigger2 on site2)
5) row is inserted in table2 on site2 (second row? as one row was inserted on step 4 above?)
I have a table1 on which i have trigger1 which fires on insert of table1 and inserts some value in table2. If I replicate table1, table2 and trigger1 on site to using golden gate, what will happen on site 2 when a row will be inserted in table 1.
Source
1) insert a row in table1
2) trigegr1 fires and inserts in table2
3) data is replicated on site 2
4) row is inserted in table1 on site2 (will it fire trigger2 on site2)
5) row is inserted in table2 on site2 (second row? as one row was inserted on step 4 above?)
0