DBMS table : Table or View does not exist
918847Mar 6 2012 — edited Mar 6 2012Hi,
we have upgraded our databases from 10g to 11g, we have multiple schema's in single database for each individual client we use one schema.
oracle version details:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
randomly we get "ORA-00942: table or view does not exist" in different pages, As per oracle DBA advice we have enable a alert event to find which original object causing the issue
by setting the below event on alert.
alter system set events '942 trace name errorstack level 1';
then we waited for the issue to occur in prod and went to the alert log file we could see below object is causing the issue:
Trace file /u01/app/oracle/diag/rdbms/cos1_hdc/COS1/trace/COS1_j001_57344024.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1
System name: AIX
Node name: usdhc8641
Release: 1
Version: 6
Machine: 00F61FB54C00
Instance name: COS1
Redo thread mounted by this instance: 1
Oracle process number: 33
Unix process pid: 57344024, image: oracle@usdhc8641 (J001)
*** 2012-02-24 22:02:18.384
*** SESSION ID:(88.3893) 2012-02-24 22:02:18.385
*** CLIENT ID:() 2012-02-24 22:02:18.385
*** SERVICE NAME:(SYS$USERS) 2012-02-24 22:02:18.385
*** MODULE NAME:(DBMS_SCHEDULER) 2012-02-24 22:02:18.385
*** ACTION NAME:(ORA$AT_SA_SPC_SY_7602) 2012-02-24 22:02:18.385
__Error Stack Dump__*
__ORA-00942: table or view does not exist__*
__Current SQL Statement for this session (sql_id=1bf67407k8px0)__*
__drop table "GAE13".DBMS_TABCOMP_TEMP_ROWID1 purge__*
__PL/SQL Stack__*
This is an DBMS table i have no clue y this sql statement is executing and where it is coming from, does any one have any idea about this.
Thanks for the help:)
Edited by: user6382611 on Mar 6, 2012 6:12 AM