| Replication using triggers. Urgent! [message #41158] |
Tue, 03 December 2002 03:26  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
