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

If you want to find out, set event='942 trace name errorstack level 1' in your parameter file, and create a database.

As soon as the error is hit, you will find a tracefile in diag/rdbms/db_unique_name/SID/trace showing you the failing SQL statement.

Regards

Stefan

On Fri, Dec 19, 2008 at 3:56 PM, dba1 mcc <mccdba1_at_yahoo.com> wrote:

> 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