First thing to do might be to post your creation script. _____ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Prasad Sent: Friday, September 21, 2007 12:06 AM To: oracle-l Subject: materialized view creation is hanging All, I am trying to create a materialized view on 10.2.0.3 db on solaris . and it is just sitting there doing nothing . but when I try to run the query it executes very fast. I tried to search metalink and google on it but didnt find any clue . I have also done the stats for all the underlying table . would appreciate any suggestions. regards -Prasad