首先要说明,这与表空间没关,只能用户控制相同表名,ok!create trigger a_tri before insert or update or delete on a for each row begin if insterting then insert into another_user.a values(:new.col1,....); elsif updating then update another_user.a set col=:new.col where id=:new.id; else delete from another_user.a where id=:old.id; end if; end; /
before insert or update or delete on a
for each row
begin
if insterting then
insert into another_user.a values(:new.col1,....);
elsif updating then
update another_user.a set col=:new.col where id=:new.id;
else
delete from another_user.a where id=:old.id;
end if;
end;
/