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/oe
oe@ttorcl_src |
| No Format |
|---|
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
); |
2. Insert data into this table and commit the data.
| No Format |
|---|
SQL> insert into sales values ( 101, 201, 233, 1299, null, 'overdueOVERDUE');
insert into sales values ( 102, 301, 30, 1099, 1099, 'paidPAID');
insert into sales values ( 103, 401, 30, 120, 120, 'paidPAID');
insert into sales values ( 104, 401, 40, 160, null, 'overdueOVERDUE');
commit; |
3. The replication console will show the new table. The DDL and the DML will be replicated so the table will be in sync on the target database.
| No Format |
|---|
OE.SALES: 100% Mine:4/4 Unrecov:0/0 Applied:4/4 |
4. Go . Synchronization may take some time, depending on your virtualized environment. Go to the target database and verify that the data is in sync.
| No Format |
|---|
sqlplus oe/oe
oe@ttorcl_trg |
| No Format |
|---|
SQL> select * from sales;
PROD_ID CUST_ID QUANTITY_SOLD AMOUNT_SOLD AMOUNT_RECEIVED SALES_STAT
---------- ---------- ------------- ----------- --------------- ----------
101 201 233 1299 overdueOVERDUE
102 301 30 1099 1099 paidPAID
103 401 30 120 120 paidPAID
104 401 40 160 overdue |
...