Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle and materialized view
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