...
| No Format |
|---|
SQL> update SALES set AMOUNT_RECEIVED = 120
where SALES_STATUS = 'OVERDUE'
and PROD_ID = 101;
commit; |
4. This will create a conflict because the update statement will be replicated to the target database. The target value was already changed and so a conflict was created.
...
| No Format |
|---|
dbvrep> list conflict Information for conflict 724010046998 (current conflict): Table: OE.SALES at transaction 001e.008.00000060 at SCN 148585373144514 SQL text (with replaced bind values): update OE."SALES" set AMOUNT_RECEIVED = 120 where (1=1) and AMOUNT_RECEIVED IS NULL and PROD_ID = 101 Error: Command affected 0 row(s). Handled as: PAUSE Conflict repeated 21 times. |
...