Home » Server Options » Streams & AQ » update errors overwrite
update errors overwrite [message #269132] Thu, 20 September 2007 15:28 Go to next message
Messages: 1
Registered: September 2007
Junior Member

We have streams set up bidirectionally such that all transactions in the custom schema are stream'd to an identical schema in a separate instance. There are no triggers, and the architects have defined specific transactions to take place in one instance or the other such that we should not see the same records being updated in both instances. However, this is a restriction built only into the application, so conflicts may occur.

In the event of a conflict, we want to first examine the conflict before a fix is applied.

Is it possible to create a procedure that will automatically apply an LCR, overwriting the conflict, that is neutral regarding the table? We have over a thousand tables and do not want to write handlers for each and every table.
Re: update errors overwrite [message #269491 is a reply to message #269132] Sat, 22 September 2007 22:13 Go to previous message
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

What about schema level?
Previous Topic: Can we use joins, where & subquery using streams
Next Topic: error in database link during propagation
Goto Forum:

Current Time: Thu Aug 18 04:51:01 CDT 2022