1. Resolve Resolve the conflict. There are different options to resolve the conflict. They All options can be viewed here: Resolving Current Conflict.
In this case the update is going to be forced on the target so that both source and target will be in sync. The conflict handler is OVERWRITEour case we have to choose, which value do we need on target database. We decided, that we want to have both databases in sync, so we choose OVERWRITE method as a conflict resolution: conflict id in our case is 65010063922
| No Format |
|---|
dbvrep> resolve conflict 72401004699865010063922 as OVERWRITE |
| Note | ||
|---|---|---|
Use command "help resolve conflict" to view information about this command
|
2. The conflict will be resolved. The OVERWRITE removes the the "AMOUNTPRODUCT_RECEIVED IS NULLNAME" from condition from the where WHERE clause to enable the update to proceed. and checks the target value only for existence of primary key column values (PRODUCT_ID).
The command console will no longer show the conflict . Note the Conflicts counter for table OE.SALES shows 1and the apply process starts to apply other transactions:
| No Format |
|---|
APPLYMINE IS running. Currently at plog 72465 and SCN 148841021490344 (1202/2915/20132015 1511:2119:3807). ... OE.SALES: APPLY IS running. Currently at plog 65 and SCN 1490318 (02/15/2015 11:19:01) ... REPOE.PRODUCT_INFORMATION: 100% Mine:57/57 Unrecov:0/0 Applied:57/51 Conflicts:1/1 Last:29/12/2013 15:19:04/OK |
3. Compare both tables on source and target and verify that they are the same:
| No Format |
|---|
SQL>REPOE@SOURCE> select * from sales; PROD_ID CUST_ID QUANTITY_SOLD AMOUNT_SOLD AMOUNT_RECEIVED SALES_STATproduct_id, product_name from repoe.product_information where product_id=100; PRODUCT_ID PRODUCT_NAME ---------- ---------- ------------- ----------- --------------- ---------- 101 100 Dbvisit 201 233 Replicate 1299REPOE@TARGET> select product_id, product_name from 120 OVERDUE 102 301 30 1099 1099 PAID 103 401 30 120 120 PAID 104 401 40 160 OVERDUErepoe.product_information where product_id=100; PRODUCT_ID PRODUCT_NAME ---------- -------------------------------------------------- 100 Dbvisit Replicate |