Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle materialized view strange problem.

Oracle materialized view strange problem.

From: Jack <amitkr.3_at_gmail.com>
Date: 25 Apr 2006 02:23:57 -0700
Message-ID: <1145957037.382383.172390@i40g2000cwc.googlegroups.com> 





Hi,



This problem is driving us crazy.




We have 2 databses (A & B).Initially both were 8i (we never faced this
problem then). Now B is 10g.



One query at 'A' uses a fast refreshing materialized view based on one
table of 'B'.



At one time this query runs without any problem (1-2 minutes ) and
moments later the exact query takes a long time (I left it running and
it completed in 20hrs).



Any help will be greatly appreciated.



Many Thanks
Received on Tue Apr 25 2006 - 04:23:57 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US