...
Open any SQL tool, connect as repoe/repoe@TTORCL_SRCrepoe@SOURCE to source database and run following command:
| No Format | ||
|---|---|---|
| ||
REPOE@TTORCL_SRC>[oracle@source replicate]$ sqlplus repoe/repoe@SOURCE SQL> insert into REPOE.CARD_DETAILS (card_id, customer_id, card_type, card_number, expiry_date, is_valid, security_code) values (CARD_DETAILS_SEQ.nextval, 1287, 'REPOE_TEST', 9102450385, sysdate, 'Y', 1000 ); 1 row created. REPOE@TTORCL_SRC> SQL> commit; Commit complete. |
Now look at the dbvrep console, if the row was successfully replicated;
...
When we see in the console, that the row was sucessfully replicated to the target database, we should check, if it is correctly replicated. Connect to target database as user repoe/repoe and run following command:
| No Format | ||
|---|---|---|
| ||
[oracle@source replicate]$ sqlplus repoe/repoe@TARGET SQL> set lines 200 pages 999 SQL> select * from REPOE.CARD_DETAILS where card_type='REPOE_TEST'; CARD_ID CUSTOMER_ID CARD_TYPE CARD_NUMBER EXPIRY_DATE I SECURITY_CODE ---------- ----------- ------------------------------ ----------- ------------------ - ------------- 750005750004 1287 REPOE_TEST 9102450385 2225-JANMAY-1517 Y 1000 |