Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to synchronize two tables using UPDATE triggers?
Hi there,
I ran into the problem of synchronizing two tables, say table A and table B using update triggers. What I hope to see is once a row in table A is updated, the correspdoning row in table B is updated right away to reflect the change, and vice versa. My first thought was to implement an AFTER update row trigger on both tables, but I realize afterwards that it will end up with recursive loop, i.e. table A trigger fires table B trigger which fires table A trigger again... Does anybody happens to know any work around with this problem, or you have better way to synchronize two tables without using triggers?
Thanks a lot in advance.