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.
If the ORA-06512 is a table related to Replication, you have a bug :(
You have to contact Oracle Support so they help you to fix the table DEF$_PROPAGATOR.
Don't do it by yourself!
Always do backups! ;)
Thanks so much for the help. That was exactly the problem. My def$_propagator had 2 rows instead of 1. After deleting the extra row the problem was resolved....
Click Here to Expand Forum to Full Width