Sami Seerangan wrote: >Could someone please let me know why this is happening and how to >overcome this issue? > > Reading manuals would be a good start and would definitely help you overcome the issue. The fine manual tells you that you cannot use fast refresh with group functions. I doubt that this group is meant as a replacement for the concepts manual. Now, I have a question: what is the meaning of the string "dba.orcl" in your email address? -- Mladen Gogala Oracle DBA Ext. 121 -- //www.freelists.org/webpage/oracle-l