Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

...