Re: Oracle and materialized view

Umbi wrote:
> 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
>

Oempf! That does not leave much room for errors (2nd DB down, network down, etc).

Maybe there's something running, that uses much CPU, and your query is just dead slow?

Any way - the DBA is to figure that out.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...