...
Check on target database that the row does not exist on the target:
| Code Block | ||||
|---|---|---|---|---|
| ||||
select count(*) from REPOE.CARD_DETAILS where card_type='REPOE_TEST';
COUNT(*)
----------
0
|
...
Open any SQL tool, connect as repoe/repoe@TTORCL_SRC to source database and run following command:
| Code Block | ||||
|---|---|---|---|---|
| ||||
REPOE@TTORCL_SRC> insert into REPOE.CARD_DETAILS (card_id, customer_id, card_type, card_number, expiry_date, is_valid, security_code) 2 values (CARD_DETAILS_SEQ.nextval, 1287, 'REPOE_TEST', 9102450385, sysdate, 'Y', 1000 ); 1 row created. REPOE@TTORCL_SRC> commit; Commit complete. |
Now look at the dbvrep console, if the row was successfully replicated;
| Code Block | title | Output of dbvrep console
|---|
Progress of replication repoe:MINE->APPLY: total/this execution ------------------------------------------------------------------------------------------------------------------ REPOE.CARD_DETAILS: 100% Mine:1/1 Unrecov:0/0 Applied:1/1 Conflicts:0/0 Last:22/01/2015 23:23:54/OK ------------------------------------------------------------------------------------------------------------------ |
...