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