Replication error - ORA-01422
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Replication error - ORA-01422

  1. #1
    Join Date
    Jul 2000
    Posts
    31
    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.

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

    Smile

    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