Home » Server Options » Replication » Update/Delete conflict resolution
Update/Delete conflict resolution [message #75367] Sun, 18 May 2003 10:41
Sergey Balter
Messages: 1
Registered: May 2003
Junior Member
Hi, All,

I'd like to resolve a conflict in multimaster
environment (Oracle 8.1.4) in a case like below:

1-st site: DELETE FROM test WHERE Id = 1
2-nd site: UPDATE test SET ... WHERE Id = 1

At the 1-st site I should get a delete/update conflict
(updating record that no longer exists).
I'd like to create a handler that will manually RESOLVE

But I have not found a way in manuals. Only hint I've found is in A76958-01 (Replication manager API Reference) that it's possible although difficult:

"If you perform a delete at the local site and an update at the remote site, the remote site detects the delete conflict, but the local site detects an unresolvable update conflict.
This type of conflict cannot be handled automatically. The conflict raises a NO_DATA_FOUND exception and Oracle logs the transaction as an error transaction.

Designing a mechanism to properly handle these types of
update/delete conflicts IS DIFFICULT. It is far easier to avoid these types of conflicts entirely, by simply "marking" deleted rows, and then purging them using procedural replication."

I'l appreciate you very much if you give me a direction.
Previous Topic: How to replicate the database
Next Topic: Snapshot space problem
Goto Forum:

Current Time: Fri Sep 24 18:50:55 CDT 2021