Oracle Database Discussions

Hi,

My db is 10gR2 on linux5.I am having ORA-12012: error on auto execute of job in my alert log file.
Errors in file /opt/app/oracle/admin/bdump/devora01_j000_10228.trc:
ORA-12012: error on auto execute of job 1848
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457
ORA-06512: at "SYS.DBMS_IREFRESH", line 685
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
Tue Aug 19 03:06:37 2008
Errors in file /opt/app/oracle/admin//bdump/devora01_j000_10228.trc:
ORA-12012: error on auto execute of job 1849
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457
ORA-06512: at "SYS.DBMS_IREFRESH", line 685
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
Tue Aug 19 03:06:43 2008
Thread 1 advanced to log sequence 189768 (LGWR switch)
Current log# 3 seq# 189768 mem# 0: /ora04/oradata/DEVORA01/redo03a.log
Current log# 3 seq# 189768 mem# 1: /ora05/oradata/DEVORA01/redo03b.log
Tue Aug 19 03:08:32 2008
Errors in file /opt/app/oracle/admin/DEVORA01/bdump/devora01_j000_10317.trc:
ORA-12012: error on auto execute of job 1848
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457
ORA-06512: at "SYS.DBMS_IREFRESH", line 685
ORA-06512: at "SYS.DBMS_REFRESH", line 195

TRACE FILE O/P:
$vi /opt/app/oracle/admin/DEVORA01/bdump/devora01_j000_10228.trc

*** ACTION NAME:() 2008-08-19 03:06:32.383
*** MODULE NAME:() 2008-08-19 03:06:32.383
*** SERVICE NAME:(SYS$USERS) 2008-08-19 03:06:32.383
*** SESSION ID:(141.53923) 2008-08-19 03:06:32.383
*** 2008-08-19 03:06:32.383
ORA-12012: error on auto execute of job 1848
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457
ORA-06512: at "SYS.DBMS_IREFRESH", line 685
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
*** SERVICE NAME:(SYS$USERS) 2008-08-19 03:06:37.319
*** SESSION ID:(141.53925) 2008-08-19 03:06:37.319
*** 2008-08-19 03:06:37.319
ORA-12012: error on auto execute of job 1849
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457
ORA-06512: at "SYS.DBMS_IREFRESH", line 685
ORA-06512: at "SYS.DBMS_REFRESH", line 19


I understood that table or view does not exist for which this auto executed job code is pointing to. I would like to look at the code to identify the table which its actually referring to. Can any one tell me how identify that?

I have seen lot of error messages posted in this forum related to this error message but none of them helped me. I looked at all_jobs, dba_jobs, user_jobs,dba_scheduler_job_run_details, dba_scheduler_job_log but i couldn't find the information related to the jobs 1848 & 1849.

Can anyone have any ideas please........

Thanks