Versions Compared

Old Version 2

changes.mady.by.user Jaimes Booth (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user Paul Steffensen (Unlicensed)

Saved on

Key

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

1. 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. In this case the conflict ID is 724010046998

No Format
dbvrep> resolve conflict 724010046998 as OVERWRITE
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 WHERE clause to enable the update to proceed. The command console will no longer show the conflict. Note the Conflicts counter for table OEREPOE.SALES shows 1.

No Format
APPLY IS running. Currently at plog 724 and SCN 14884102 (12/29/2013 15:21:38).3144515
...
OEREPOE.SALES:                     100%  Mine:5/5             Unrecov:0/0         Applied:5/5         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. The value for amount_received for prod_id 101 should be 120 on both source and target.

No Format
SQL> select * from sales;
   PROD_ID    CUST_ID QUANTITY_SOLD AMOUNT_SOLD AMOUNT_RECEIVED SALES_STAT
---------- ---------- ------------- ----------- --------------- ----------
       101	        201		233	           233        1299 	             120 OVERDUE
       102	        301		 30	            30        1099 	            1099 PAID
       103	        401		 30	            30         120 	             120 PAID
       104	        401		 40	            40         160 		                 OVERDUE