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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle and materialized view

Re: Oracle and materialized view

From: Umbi <umberto.michelucci_at_bluewin.ch>
Date: 22 Feb 2006 23:38:21 -0800
Message-ID: <1140680301.440127.128900@o13g2000cwo.googlegroups.com>


Actually the tables are on two schemas but on the same instance. The problem is that on Friday morning everything runs ok, and on Saturday morning the query takes too long too complete (actually they DON'T complete). If one tries manually to create a new materialzed view the query don't come back anymore.

Thanks for the help,
Umberto Received on Thu Feb 23 2006 - 01:38:21 CST

Original text of this message

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