1. Create a new table in the source database. On the source server (dbv01) logon as the OE schema and create a new table
| No Format |
|---|
sqlplus oe/oeoe@ttorcl_src SQL> create table sales ( prod_id number primary key, cust_id number not null, quantity_sold number(10,2) not null, amount_sold number(10,2) not null, amount_received number(10,2), sales_status varchar2(10) not null ); |
...
4. Go to the target database and verify that the data is in sync
| No Format |
|---|
sqlplus oe/oeoe@ttorcl_trg SQL> select * from sales; PROD_ID CUST_ID QUANTITY_SOLD AMOUNT_SOLD AMOUNT_RECEIVED SALES_STAT ---------- ---------- ------------- ----------- --------------- ---------- 101 201 233 1299 OVERDUE 102 301 30 1099 1099 PAID 103 401 30 120 120 PAID 104 401 40 160 OVERDUE |
...