Re: All jobs are failing with ORA-01427 (WAS: Automatic refresh of snapshot is failing)

On Thu, 10 Jul 2003 09:35:09 -0700, Anne Nolan <MUNGEanneDOTnolanNOSPAM_at_rts-group.com> wrote:

>On further digging (into a different database on a different server we also
>have), I've discovered that all jobs are failing with the same error:
>ORA-12012: error on auto execute of job 21
>ORA-01427: single-row subquery returns more than one row
>ORA-06512: at line 11
>
>Some of these jobs are for materialized view refreshes, while others just run
>a stored procedure.
>
>Both servers run Oracle 8.1.7.0.0
>One is WinNT4 SP6, while the other is Windows 2000 Version 5.0.
>
>Can anyone shed any light as to what's going on?
>
>Thanks for any help,
>
>Anne Nolan
>
>
>
>

Isolate the query and execute it independently. Alternatively set event='1427 errorstack trace name level 3' in your init.ora and bounce the database

>

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jul 10 2003 - 12:41:31 CDT