--创建一个dblink
create database link to_center
connect to gbw(用户名) identified by neusoft(密码)
using '(description=
(address_list =
(address = (protocol=tcp)(host=10.10.90.137(ip地址))(port=1521))
)
(
connect_data = (service_name = center_trans(数据库实例名))
)
)';
--创建一个trigger
create or replace trigger sync_gbsy_report_item_trigger --自定义的触发器的名称
after insert or update or delete on gbsy_report_item_cft for each row
declare
变量声明;
begin
if inserting then
insert into gbsy_report_item_cft@to_center
(
report_item_id,
report_id,
count_time,
progam_name,
language
)
values
(
gbsy_report_item_seq.nextval,
:new.report_id,
:new.count_time,
:new.progam_name,
:new.language
);
elsif updating then
update gbsy_report_item_cft@to_center
set report_id = :new.report_id,
count_time = :new.count_time,
progam_name = :new.progam_name,
language = :new.language
where report_item_id = :old.report_item_id;
elsif deleting then
delete from gbsy_report_item_cft@to_center where report_item_id = :old.report_item_id;
end if;
end sync_gbsy_report_item_trigger;
create database link to_center
connect to gbw(用户名) identified by neusoft(密码)
using '(description=
(address_list =
(address = (protocol=tcp)(host=10.10.90.137(ip地址))(port=1521))
)
(
connect_data = (service_name = center_trans(数据库实例名))
)
)';
--创建一个trigger
create or replace trigger sync_gbsy_report_item_trigger --自定义的触发器的名称
after insert or update or delete on gbsy_report_item_cft for each row
declare
变量声明;
begin
if inserting then
insert into gbsy_report_item_cft@to_center
(
report_item_id,
report_id,
count_time,
progam_name,
language
)
values
(
gbsy_report_item_seq.nextval,
:new.report_id,
:new.count_time,
:new.progam_name,
:new.language
);
elsif updating then
update gbsy_report_item_cft@to_center
set report_id = :new.report_id,
count_time = :new.count_time,
progam_name = :new.progam_name,
language = :new.language
where report_item_id = :old.report_item_id;
elsif deleting then
delete from gbsy_report_item_cft@to_center where report_item_id = :old.report_item_id;
end if;
end sync_gbsy_report_item_trigger;