Home » Server Options » Replication » Update with Replication is not OK!!!
Update with Replication is not OK!!! [message #75402] Mon, 03 November 2003 05:40 Go to next message
pg
Messages: 12
Registered: May 2002
Junior Member
I have a problem with the replication. I have two table (A1 site A and A1 site B) in replication of type sync. When I do insert into A1 of B the replication do insert in A1 of A. In A1 of site A there is a trigger that it do a update in other table A2 (site A) that is replicate in site B in mode async. The update on A2 site A is OK but in A2 of site B is non OK.
Why?
Can you help me?
Thank you
Re: Update with Replication is not OK!!! [message #75405 is a reply to message #75402] Tue, 04 November 2003 12:54 Go to previous message
James
Messages: 120
Registered: June 2000
Senior Member
I suspect you are getting a mutating table error. This is caused because the status of the first transaction is still in flux (until the commit of the trigger/rep on the second table). It would also help to know if this is an after or before trigger. In either case, you best bet is to seperate the transactions, and allow the first transaction to complete before attempting the second one.
Previous Topic: Very URGENT !!!!!! Oracle Migration Help !!!!!!!!!!
Next Topic: What is Materialized View?
Goto Forum:
  


Current Time: Thu Mar 28 08:42:32 CDT 2024