Home » Server Options » Replication » trigger: after update on materialized view (Oracle:10.2.0.1.0)
trigger: after update on materialized view [message #324047] Fri, 30 May 2008 07:16 Go to next message
adnanBIH
Messages: 41
Registered: November 2007
Location: BiH, Sarajevo
Member
Hello. I'm facing the next problem:
i want to create "on update" database trigger on materialized view which is on replication schema.
I would like to update rows in table when update occurs on materialized view on master side.
I wrote some code and tried with this:

CREATE OR REPLACE TRIGGER a
after update on A@dirfep.us.oracle.com
FOR EACH ROW
BEGIN
IF ((:old.b != :new.b) OR (:old.c != :new.c)) THEN
update pr_prim_pos set c1=:new.c,d=:new.d1,e1=:new.e
where c1=:old.c;
END IF;
END a;

Thank you in advance.
Re: trigger: after update on materialized view [message #324050 is a reply to message #324047] Fri, 30 May 2008 07:30 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't create a trigger on a remote table.

Regards
Michel
Previous Topic: Alter mview (Query)
Next Topic: Query on advanced replication
Goto Forum:
  


Current Time: Thu Mar 28 06:20:32 CDT 2024