RE: Create database on 11.0.1.7 have ORA-00942 message???
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <mccdba1@xxxxxxxxx>, "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- Date: Mon, 22 Dec 2008 11:40:22 -0500
One of three possible reasons:
1) the object really does not exist (look in dba_objects to find
out)
2) the user does not have permissions on the table (look in
dba_tab_privs).
3) a synonym from the logged in user to the object does not
exist (look in dba_synonyms).
Dick Goulet
Senior Oracle DBA
PAREXEL International
978.313.3426
information transmitted in this communication is intended only for the
person or entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this information
by persons or entities other than the intended recipient is prohibited.
If you received this in error, please destroy any copies, contact the
sender and delete the material from any computer.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of dba1 mcc
Sent: Monday, December 22, 2008 11:23 AM
To: Stefan Knecht
Cc: oracle-l
Subject: Re: Create database on 11.0.1.7 have ORA-00942 message???
Thank you for help.
I set trace for ORA-00942 and trace file show:
----- Error Stack Dump -----
----- Current SQL Statement for this session (sql_id=9smyv3uv3zvxm)
-----
select ROWID from SYS_MFBA_STAGE_RID where ROWNUM = 1
any ideal???
--- On Fri, 12/19/08, Stefan Knecht <knecht.stefan@xxxxxxxxx> wrote:
> From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
> Subject: Re: Create database on 11.0.1.7 have ORA-00942 message???
> To: mccdba1@xxxxxxxxx
> Cc: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
> Date: Friday, December 19, 2008, 10:11 AM
> 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@xxxxxxxxx> 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
> >
> >
> >
> > --
> > //www.freelists.org/webpage/oracle-l
> >
> >
> >
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
