Re: Create database on 11.0.1.7 have ORA-00942 message???
- From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- To: mccdba1@xxxxxxxxx
- Date: Mon, 22 Dec 2008 19:20:44 +0100
Interesting ... This is part of Oracle Flashback archive (Total Recall). It
is definitely safe to ignore.
Cheers
Stefan
On Mon, Dec 22, 2008 at 5:22 PM, dba1 mcc <mccdba1@xxxxxxxxx> wrote:
> 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
> > >
> > >
> > >
>
>
>
>
Other related posts:
