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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.