...
What happened? The apply process is still stuck. The count of conflicts raised by 1 and apply is again waiting for manual resolution. Lets check the conflicts again:
Code Block |
---|
dbvrep> list conflict Information for conflict 32010159942 (current conflict): Table: REPOE.LOGON at transaction 000a.01f.000001df at SCN 653533 SQL text (with replaced bind values): update "REPOE"."LOGON" set "LOGON_ID" = 100000000 where (1=1) and "LOGON_ID" = 1000000 and "CUSTOMER_ID" = 496840 and "LOGON_DATE" = to_date('2006.03.31 04:18:40','yyyy.mm.dd hh24:mi:ss') Error: Command affected 2 row(s). Handled as: PAUSE Conflict repeated 21 times. |
...
Now we have to check whether our two rows got replicated:
Code Block |
---|
REPOE@TTORCL_trg> select count(*) from repoe.logon where logon_id=1000000; COUNT(*) ---------- 0 REPOE@TTORCL_trg> select count(*) from repoe.logon where logon_id=100000000; COUNT(*) ---------- 2 |
...