...
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, where the row has already different value, than the source.
...