Oracle - Explain how to resolve replication conflicts. posted by
Babu Kunwar
Explain how to resolve replication conflicts.
Conflict means that there are two materialized view of your db for example A and
B, and if both update a column at same time then conflict occurs. In order to
resolve the replication conflict the first thing that must be kept in mind, is
before configuring the replication environment we need to look whether our
application can suffer conflict or not. This is the one way to resolve the
conflict. As if you configure the environment by keeping conflict point in
mind. Then when conflict occurs the data of system will not meet unless and
until the conflict is resolved.
But using a Oracle database is a blessing as it provides various methods for
resolving with the different types of conflict. Remember: But you cannot delete
the conflict from database neither can’t you create your own method as Oracle
does not allow you to do so. But if you wish you can. To resolve the conflict
Oracle provides built-in method for resolving with the conflicts for e: g:
TIMESTAMP. Further in order to avoid the conflict in multi materialized view we
need to provide conflict resolution method in each view.
More links
What are Cursors?
Define cursor attributes: %FOUND, %NOTFOUND, %ROWCOUNT, and %ISOPEN
What are cursor variables? Explain with an example
Significance of SELECT FOR UPDATE clause. Write syntax
Significance of WHERE CURRENT OF clause. Write syntax..........
|
