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

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_at_yahoo.com> 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_at_gmail.com> 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_at_yahoogroups.com
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
> ________________________________
> Do you Yahoo!?
> Yahoo! Sports - Sign up for Fantasy Baseball.
>
>

--
http://www.freelists.org/webpage/oracle-l