1. Resolve Resolve the conflict. There are different options to resolve the conflict. They 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 OVERWRITE. because we already updated the target, so at this moment the values are the same on target as well as on source, we will choose IGNORE as a resolve conflict handler: In this case the conflict ID is 724010046998is 65010063922
| No Format |
|---|
dbvrep> resolve conflict 72401004699865010063922 as OVERWRITEIGNORE |
| Note |
|---|
Use command "help resolve conflict" to view information about this command | No Format |
|---|
dbvrep> help resolve conflict
RESOLVE: RESOLVE CONFLICT id AS resolution: Resolve conflict on apply as IGNORE, IGNOREALL, OVERWRITE, FORCE, RETRY, RESTART, ROLLBACK or ABORT. |
|
2. The conflict will be resolved. The OVERWRITE removes the "AMOUNT_RECEIVED IS NULL" from the WHERE clause to enable the update to proceedIGNORE throws the conflicting update and enables the apply process to continue apply other changes. The command console will no longer show the conflict. Note the Conflicts counter for table REPOE.SALES shows 1.
| No Format |
|---|
APPLYMINE IS running. Currently at plog 72465 and SCN 3144515
...
REPOE.SALES: 1490344 (02/15/2015 11:19:07).
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 |
3. Compare both tables on source and target and verify that they are the same. The value for amount_received for prod_id 101 should be 120 on both source and target.:
| No Format |
|---|
REPOE@ttorcl_src> 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
---------- ---------- ------------- ----------- --------------- ----------
101100 Dbvisit Replicate
REPOE@TTORCL_TRG> select 201 233product_id, product_name from repoe.product_information where product_id=100;
PRODUCT_ID PRODUCT_NAME
---------- --------------------------------------------------
100 1299 120 OVERDUE
102 301 30 1099 1099 PAID
103 401 30 120 120 PAID
104 401 40 160 OVERDUEDbvisit Replicate
|