Hi:

I am trying to setup Multimaster replication between two databases (Synchronous) using the Replication Manager. It appears to create the master group successfully. But when I try to insert a row into the table I get the error:

ORA-00604: error occurred at recursive SQL level 2
ORA-01422: exact fetch returns more than requested number of rows

I have checked the number of rows in the dual table and it is one. All my tables have primary keys. Does anybody have any ideas as far as what else I can check.

The version of Oracle is 8.1.5 running on Solaris 8.

Thanks for all your help.

- Una.