Home » Server Options » Replication » Synchrounous replication
Synchrounous replication [message #75350] Thu, 27 March 2003 23:29
Nagaraj
Messages: 11
Registered: December 1999
Junior Member
i have set up multimaster replication -sysnchrounous . while updating from a master site shows up the Operation System:

Microsoft Windows 2000 Advanced Server
Version 5.0 (build 2195 : Service Pack 3)

Database:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production

Problem Description:

We have configured Synchronous Multimaster replication in our OLTP Environment.Working fine for single record update/delete operation. when i try to update or delete multiple rows in a single query,i get the foolwing error messages in different scenerios.Please send me some valid suggestions at the earliest.

ORA-02055: distributed update operation failed; rollback required
ORA-01422: exact fetch returns more than requested number of rows

Workaround for better understand.

SQL> select * from reptest;

ID NAME
---------- --------------------
22 HHH
33 CHN
33 CHN
33 CHN
8 ASD
2 ASD
9 WAS
10 DER
21 TST

9 rows selected.

SQL> insert into reptest values(34,'PPPP');

1 row created.

SQL> commit;

Commit complete.

SQL> update reptest set name='NAG' where id=33;
update reptest set name='YUYU' where id=33
*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows

SQL> delete from reptest;
delete from reptest
*
ERROR at line 1:
ORA-02055: distributed update operation failed; rollback required
ORA-01422: exact fetch returns more than requested number of rows
Previous Topic: Materialized View Concepts
Next Topic: Synchronous Multimaster relication
Goto Forum:
  


Current Time: Mon Sep 27 11:39:36 CDT 2021