新增表同步测试

1.创建之前检查源端是否存在 tab01 表
SQL>conn send/send@orala
SQL>select to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss') from dual;
SQL>select * from tab01;

2. 创建之前检查目标端是否存在 tab01 表
SQL>conn send/send@oraclb
SQL>select to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss') from dual;
SQL>select * from tab01;

3.在源端建表并插入数据
SQL>create tables tab01(id integer, name char(10));
SQL>insert into tab01 values(1, 'aaaa');
SQL>commit;
SQL>seelct to_char(sysdate, 'yyyy-mm-dd24:mi:ss') from dual;
SQL>show parameter db_name;

4.在目标端查看同步情况
SQL>conn send/send
SQL>select to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss') from dual;
SQL>select * from tab01;
SQL>show parameter db_name;