Re: Replication ora-1422 HELP!

From: Hélène Simard <hsimard_at_ville.quebec.qc.ca>
Date: Thu, 07 Oct 1999 12:01:31 -0400
Message-ID: <37FCC3DB.74486850@hotmail.com>

Hi Mario,

Stange, we have the same problem here. Good luck!

Mario Perreault a écrit :

> 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 Thu Oct 07 1999 - 11:01:31 CDT