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
|
|
|