
February 9th, 2006, 08:42 AM
|
|
Registered User
|
|
Join Date: Feb 2006
Posts: 1
Time spent in forums: 11 m 36 sec
Reputation Power: 0
|
|
|
Trigger invocation during replication
I am trying to replicate two tables from host A to host B.
I have defined after insert/update triggers on these two tables tableA and tableB. I want these triggers for these two tables to be invoked during replication. Also I want tableA to be replicated first as triggers for tableB depends on data from tableA.
The replication works fine, but triggers are not invoked at all.
Acctually the replication uses load mechanism for tableB and import mechanism for tableA. So the trigger gets fired for tableA, but not for
tableB (because load doesn't fire trigger). However I want both triggers
to get fired and also I want to replicate tableA first and tableB first.
So that trigger for tableA fires first as trigger from tableB depends on
data from tableA.
I will appreciate if you can provide a solution for my requirement.
Thanks in advance
|