...
9. Decide which value should be kept on the target database. Do you want to keep the value of AMOUNT_RECEIVED = 60 or AMOUNT_RECEIVED = 120? In this case we are going to keep the value of AMOUNT_RECEIVED = 120 as this is the value on the source system.
10. 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
| No Format |
|---|
dbvrep> resolve conflict 724010046998 as OVERWRITE |
| Note | ||
|---|---|---|
Use command "help resolve conflict" to view information about this command
|
11. The conflict will be resolved. The OVERWRITE removes the "AMOUNT_RECEIVED IS NULL" from the where clause to enable the update to proceed. The command console will no longer show the conflict. Note the Conflicts counter for table OE.SALES shows 1
| No Format |
|---|
APPLY IS running. Currently at plog 724 and SCN 14884102 (12/29/2013 15:21:38).
...
OE.SALES: 100% Mine:5/5 Unrecov:0/0 Applied:5/5 Conflicts:1/1 Last:29/12/2013 15:19:04/OK |
11. Compare both tables on source and target and verify that they are the same
| No Format |
|---|
SQL> select * from sales;
PROD_ID CUST_ID QUANTITY_SOLD AMOUNT_SOLD AMOUNT_RECEIVED SALES_STAT
---------- ---------- ------------- ----------- --------------- ----------
101 201 233 1299 120 OVERDUE
102 301 30 1099 1099 PAID
103 401 30 120 120 PAID
104 401 40 160 OVERDUE |