Oracle Snapshot/ Job [message #62537] |
Tue, 27 July 2004 13:10 |
Henning
Messages: 6 Registered: October 2001
|
Junior Member |
|
|
I have the following problem:
I work on a Oracle 8i database. I have created a snapshot. This repeats only 16 times and then it is marked as broken. I also tried to create a job, which repeats every hour. When I look into the USER_JOBS it counts the field FAILURES up to 16 and after that it marks the field BROKEN to 'Y'. I tried to chang the init.ora but nothing change.
I hope somebody can help me.
Best regards
Henning
|
|
|
|
Re: Oracle Snapshot/ Job [message #62592 is a reply to message #62538] |
Mon, 02 August 2004 04:00 |
Henning
Messages: 6 Registered: October 2001
|
Junior Member |
|
|
But when I look at the trace file I found a little bit stupid message:
Mon Aug 1 12:03:08 2004
Errors in file D:oracleadminorawsp8bdumporawsp8.NSP0.TRC:
ORA-12012: error on auto execute of job 121
ORA-01427: single-row subquery returns more than one row
ORA-06512: at line 3
Mon Aug 1 12:05:10 2004
Errors in file D:oracleadminorawsp8bdumporawsp8.NSP0.TRC:
ORA-12012: error on auto execute of job 121
ORA-01427: single-row subquery returns more than one row
ORA-06512: at line 3
Mon Aug 1 12:07:12 2004
Errors in file D:oracleadminorawsp8bdumporawsp8.NSP0.TRC:
ORA-12012: error on auto execute of job 121
ORA-01427: single-row subquery returns more than one row
ORA-06512: at line 3
Mon Aug 1 12:09:14 2004
Errors in file D:oracleadminorawsp8bdumporawsp8.NSP0.TRC:
ORA-12012: error on auto execute of job 121
ORA-01427: single-row subquery returns more than one row
ORA-06512: at line 3
... and so on and so on
But it is a simple query which returns ony one row!
Henning
|
|
|