01 - Create new table and insert data

1. Create a new table in the source database. On the source server (dbv01) logon as the OE schema and create a new table

sqlplus oe/oe@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
);

2. Insert data into this table and commit the data

SQL> insert into sales values ( 101, 201, 233, 1299, null, 'OVERDUE');
insert into sales values ( 102, 301, 30, 1099, 1099, 'PAID');
insert into sales values ( 103, 401, 30, 120, 120, 'PAID');
insert into sales values ( 104, 401, 40, 160, null, 'OVERDUE');
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

OE.SALES:                     100%  Mine:4/4             Unrecov:0/0         Applied:4/4

4. Go to the target database and verify that the data is in sync

sqlplus oe/oe@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

01 - Create new table and insert data

0 Comments