...
1. On the target table on the target server (dbv02), run the following SQL to update the value
| No Format |
|---|
sqlplus oe/oeoe@ttorcl_trg SQL> update SALES set AMOUNT_RECEIVED = 60 where SALES_STATUS = 'OVERDUE' and PROD_ID = 101; commit; |
...
3. Update the AMOUNT_RECEIVED for PROD_ID = 101 on the source database. On source server (dbv01) run the following SQL to update the value
| No Format |
|---|
sqlplus oe/oeoe@ttorcl_src SQL> update SALES set AMOUNT_RECEIVED = 120 where SALES_STATUS = 'OVERDUE' and PROD_ID = 101; |
...