RE: errors from alert.log

From: Tao Zuo <Tao_Zuo_at_npd.com>
Date: Mon, 7 Jun 2004 17:08:03 -0400
Message-ID: <E52FC22CD585744F968349C74D10E0A8B5C4@W2EMLVS1.npd.com>

suspect the master table is gone...

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Nguyen, David M Sent: Monday, June 07, 2004 5:04 PM
To: oracle-l_at_freelists.org
Subject: errors from alert.log

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:11:37 CDT