01 - Create new table and insert data

1. Create a new table in the source database. On the source server, using SQL*Plus, logon as the REPOE schema and create a new table.

sqlplus repoe/repoe@ttorcl_src

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.

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. By default, DDL and the DML will be replicated so the table will be in sync on the target database.

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

4. Synchronization may take some time, depending on your virtualized environment.

./record_count.bash

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