[askdba] Re: [dba_gurus] ORA-04045: n ORA-07445: - URGENT

  • From: Chirag DBA <chiragdba@xxxxxxxxx>
  • To: JH Surya Kanth <harikanth_j@xxxxxxxxx>
  • Date: Fri, 25 Feb 2005 13:11:10 +0530

Thank you and sorry to say NO.

This is not I am getting. I am getting the following error Suryakanth.

ORA-04045: errors during recompilation/revalidation of DWH.CSDATA_SERIAL_MV1

I can do complete refresh but not the fast  refresh.

Complete refresh is taking too long.



On Thu, 24 Feb 2005 23:37:50 -0800 (PST), JH Surya Kanth
<harikanth_j@xxxxxxxxx> wrote:
> Dear friend,
> 
> The following problems similar to yours just have a
> look at the following link.
> 
> http://www.freelists.org/archives/oracle-l/08-2004/msg01448.html
> 
> suryakanth
> 
> 
> --- Chirag DBA <ChiragDBA@xxxxxxxxx> wrote:
> 
> > Problem is If I refresh it completely it does
> > without any error, but
> > in the application they have done the fast refresh
> > which is giving the
> > problem.
> >
> > ORA-04045: errors during recompilation/revalidation
> > of DWH.CSDATA_SERIAL_MV1
> >
> >
> > Tareen, I have recompiled the view and general
> > things.... fine
> >
> > user is not ready to put the view as complete
> > refresh, it takes 23
> > seconds which is too tooooo long for him.
> >
> > It was a butin 8i but this is 9i R2, and this is
> > SOLARIS 8.0 version I think.
> >
> > Hope not missing anything...!!
> >
> >  - ChiraG
> >
> >
> > On Wed, 23 Feb 2005 12:51:19 -0800 (PST), Nisar
> > Tareen
> > <ntareen@xxxxxxxxx> wrote:
> > > Chirag
> > >
> > > Did you try to recompile the view or refresh  the
> > Materialized view, any
> > > luck.  Just from the top of my head.
> > >
> > > Nisar
> > >
> > >
> > > Chirag DBA <ChiragDBA@xxxxxxxxx> wrote:
> > > Guyz, anyone have gone through this problem.
> > >
> > > DWH.CSDATA_SERIAL_MV1 is a materialized view.
> > Anyone has gone through this?
> > >
> > > ORA-04045: errors during
> > recompilation/revalidation of DWH.CSDATA_SERIAL_MV1
> > > ORA-07445: exception encountered: core dump
> > [insape()+88] [SIGSEGV]
> > > [Address not mapped to object] [0x0] [] []
> > >
> > >  ________________________________
> > >  Yahoo! Groups Links
> > >
> > > To visit your group on the web, go to:
> > > http://groups.yahoo.com/group/dba_gurus/
> > >
> > > To unsubscribe from this group, send an email to:
> > > dba_gurus-unsubscribe@xxxxxxxxxxxxxxx
> > >
> > > Your use of Yahoo! Groups is subject to the Yahoo!
> > Terms of Service.
> > >
> > >
> > >  ________________________________
> > > Do you Yahoo!?
> > >  Yahoo! Sports - Sign up for Fantasy Baseball.
> > >
> > >
> >
> 
> __________________________________
> Do you Yahoo!?
> Take Yahoo! Mail with you! Get it on your mobile phone.
> http://mobile.yahoo.com/maildemo
>

Other related posts: