在oracle数据库中实现数据同步

1、分别在A数据库和B数据库上中创建一个一样的表：
create table TBL_TEST
(
  ID          VARCHAR2(100) not null,
  STATUS_NAME VARCHAR2(100),
  STATE       NUMBER
);
alter table TBL_TEST
  add primary key (ID);

2、在B数据库服务器上创建一个DBLINK
create public database link dblink_test
  connect to system identified by Oracle_Password_001
  using '(DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 11.32.18.33)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVICE_NAME = most)
   )
   )';

3、在B数据库服务器上创建同义词
       create or replace synonym TBL_TEST02  for TBL_TEST@dblink_test;

4、在B数据库服务器上创建触发器
create or replace trigger rtest
after insert on TBL_TEST
for each row
begin
insert into TBL_TEST02 (ID,STATUS_NAME,STATE) values (:new.id,:new.status_name,:new.state);
end;
/
-----------------------------------------------------------------