TFTS: SCRIPT TO ADD UPDATE CONFLICT RESOLUTION FOR UPDATABLE SNAPSHOT
(Doc ID 105205.1)
Last updated on SEPTEMBER 20, 2021
Applies to:
Oracle Database - Enterprise Edition - Version 8.0.3.0 to 11.1.0.7 [Release 8.0.3 to 11.1]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Purpose
To avoid the update conflicts in the updatable snapshot environment.
Scope
To avoid the update conflicts in the updatable snapshot environment.
ADDING UPDATE CONFLICT RESOLUTION FOR UPDATABLE SNAPSHOT WITH SITE PRIORITY
The following script will add the update conflict resolution with site priority
in the updatable snapshot environment. This script will create the priority
group and the table in the lower priority group will be updated by the data
from the higher priority table. This procedure is slightly differ from the
standard conflict resolution procedure because we need to add up the trigger
manually in the snapshot site.
The database link from snapshot site to the master site is require to setup
this environment.
Conflict may occurs when data updated in the snapshot site against the data
that has changed at the master site since the last refresh. When the PUSH job
scheduled in the snapshot site executes, will log the ORA-1403 NO-DATA_FOUND
error into the deferror View.
Details
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |