...
On the target table on the target server, run the following SQL to update the value
| No Format |
|---|
sqlplus repoe/repoe@ttorcl_trg REPOE@TTORCL_TRG>repoe@TARGET REPOE@TARGET> update REPOE.PRODUCT_INFORMATION set PRODUCT_NAME='Dbvisit Standby' where product_id=100; REPOE@TTORCL_TRG>REPOE@TARGET> commit; |
By this command we created a difference between source and target table. Situation, when target and source tables are not in sync can lead to an conflict.
...
Update the PRODUCT_INFORMATION for PRODUCT_ID=100 on the source database. On source server run the following SQL to update the value:
| No Format |
|---|
sqlplus repoe/repoe@ttorcl_src REPOE@TTORCL_SRC>repoe@SOURCE REPOE@SOURCE> update REPOE.PRODUCT_INFORMATION set PRODUCT_NAME='Dbvisit Replicate' where product_id=100; REPOE@TTORCL_SRC>REPOE@SOURCE> commit; |
This will create a conflict because the update statement will be replicated to the target database. The target value was already changed and so a conflict is created, where the row has already different value, than the source.
On the replication console the conflict will be shown:
...
The conflict itself arises, because value of PRODUCT_NAME='3qmaQueJ1Ou 5 aNzkUP8cmTjrO lvPj' and "PRODUCT_ID" = 100 cannot be found on target. Remember the ID of the conflict (65010063922). We will use this number for resolving the conflict in next chapter.
The method of using past values of columns is common for most logical replication technologies.
...