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

  • From: Chirag DBA <chiragdba@xxxxxxxxx>
  • To: Nisar Tareen <ntareen@xxxxxxxxx>
  • Date: Fri, 25 Feb 2005 12:52:40 +0530

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. 
> 
>

Other related posts: