DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2000

    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.

  2. #2
    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! ;)
    Ramon Caballero, DBA, rcaballe@yahoo.com

  3. #3
    Join Date
    Jul 2000


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

    - Una.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.