Replication ora-1422 HELP!

From: Mario Perreault <mario.perreault_at_bigfoot.com>
Date: Wed, 06 Oct 1999 23:03:31 -0400
Message-ID: <37FC0D82.433F4865@bigfoot.com>

Does anybody can help me!

We have a replication site with 3 instances with Oracle 8.0.5.2.1.

Since last monday after a shutdown/startup on one instance, the "push" jobs always failed to run. The two other instances work well.

Here an sample of what we obtain in alert.log!

Wed Oct 6 22:30:14 1999
Errors in file /tmp/ora_11968.trc:

ORA-12012: error on auto execute of job 10
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 1421
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 1481
ORA-06512: at line 1

Any help will be appreciate!

--

        \\\|||///
        /  ^ ^  \
        (  0 0  )

------oOOo-(_)-oOOo-----

mario.perreault_at_bigfoot.com Received on Wed Oct 06 1999 - 22:03:31 CDT