errors from alert.log

From: Nguyen, David M <david.m.nguyen_at_xo.com>
Date: Mon, 7 Jun 2004 17:03:53 -0400
Message-ID: <CF2C2AF8121121469722950F193435490450A2CE@ILCHICVEXC002.mail.inthosts.net>

I receive following errors from alert.log. I'd like to know root cause of the error and how to fix it. Please help.

We have oracle8.0.5 running on solaris8.  

ORA-12012: error on auto execute of job 125

 ORA-12008: error in snapshot refresh path

 ORA-00942: table or view does not exist

 ORA-02063: preceding line from SSDB.PBNA0

 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 386

 ORA-06512: at "SYS.DBMS_IREFRESH", line 450

 ORA-06512: at "SYS.DBMS_REFRESH", line 182

 ORA-06512: at line 1

 ORA-12012: error on auto execute of job 124

 ORA-12008: error in snapshot refresh path

 ORA-00942: table or view does not exist

 ORA-02063: preceding line from SSDB.PBNA0

 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 386

 ORA-06512: at "SYS.DBMS_IREFRESH", line 450

 ORA-06512: at "SYS.DBMS_REFRESH", line 182

 ORA-06512: at line 1  

Thanks,
David  

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Mon Jun 07 2004 - 16:01:05 CDT