CHAPTER 10Handling Data Conflicts

In distributed environments, where data is shared among multiple databases, the global data consistency is very important for the overall system. While each database is locally consistent, global consistency should be maintained primarily by design and administrative procedures. However, sometimes global consistency is difficult to achieve. Lack of such consistency causes data conflicts.

One of the strengths of Oracle Streams replication is automatic detection and handling of data conflicts while applying the changes. In Streams, a data conflict means the old values for the columns in the LCR do not match the existing column values in the destination table row. Such conflicts can occur when data is shared among ...

Get Oracle Streams 11g Data Replication now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.