ORA-04045: n ORA-07445: - URGENT 2005-02-25 - By Chirag DBA
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 (See ORA-04045.ora-code.com): 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@(protected)> 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@(protected)> wrote:
> Guyz, anyone have gone through this problem.
>
> DWH.CSDATA_SERIAL_MV1 is a materialized view. Anyone has gone through this?
>
> ORA-04045 (See ORA-04045.ora-code.com): errors during recompilation/revalidation of DWH.CSDATA_SERIAL_MV1
> ORA-07445 (See ORA-07445.ora-code.com): 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@(protected)
>
> 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
|
|
