Home » Server Options » Replication » Replication using triggers. Urgent!
Replication using triggers. Urgent! [message #41158] Tue, 03 December 2002 03:26 Go to next message
prashant
Messages: 122
Registered: September 2000
Senior Member
Hi all
I am using triggers to keep two tables perfect copies of each other. To prevent the triggers from recursively firing i make use of packaged variables. Now when the 2 tables r in the same database the logic works correctly and both the tables contain same data but when the tables r in different databases, from one side it works fine but from the other side i get an error :
update emp set sal = 158
*
ERROR at line 1:
ORA-02055: distributed update operation failed; rollback required
ORA-08006: specified row no longer exists

Can somebody please send me the logic to do this
Re: Replication using triggers. Urgent! [message #41174 is a reply to message #41158] Wed, 04 December 2002 07:50 Go to previous message
Anne Simms
Messages: 163
Registered: May 2002
Location: San Francisco, CA
Senior Member
It could be possible that it's not reading the information or pointing to the right database from the other database. Check the links for both the databases.
Sounds like the link could be dropping during the processes. They are basically not in sysnc, otherwise you would not be getting an error message such as Ora-02055. Ann
Previous Topic: Changing a Standby Controlfile
Next Topic: can't drop snapshot
Goto Forum:
  


Current Time: Thu Nov 26 04:40:48 CST 2020