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;
/
-----------------------------------------------------------------
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;
/
-----------------------------------------------------------------