RE: materialized view creation is hanging

  • From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
  • To: <p4cldba@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 21 Sep 2007 08:20:21 -0400

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 

Other related posts: