RE: Create database on 11.0.1.7 have ORA-00942 message???

From: Bellows, Bambi \(Comsys\) <bbel5_at_allstate.com>
Date: Fri, 19 Dec 2008 09:16:16 -0600
Message-ID: <AD0CB572A820AB4E8E52ABD38950FD3605803F8E@a0001-xpo0150-s.hodc.ad.allstate.com>


I've had problems with the asynchronous queues before, especially if you've had to restart the process for some reason. So make sure they're not there before and that the jobs queue is empty before running the script to create the AQ views. Otherwise, yeah, weird as it seems, you can get 942s on a crdb.

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc Sent: Friday, December 19, 2008 8:57 AM
To: oracle-l_at_freelists.org
Subject: Create database on 11.0.1.7 have ORA-00942 message???

We hace DELL server with Redhat 5.2 X86 installed on it. I tried to created database on ORACLE 11.1.0.7 and have message ORA-00942 in alert.log file. Database look good without problem. This messages also happen on 64 bits ORACLE 11.1.0.7. Does anyine know what it is?

ORA-00942: table or view does not exist
Starting background process QMNC
Thu Dec 18 14:19:54 2008
QMNC started with pid=19, OS id=18846
Error 604 in kwqmnpartition(), aborting txn Completed: create database       

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Dec 19 2008 - 09:16:16 CST

Original text of this message