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 -> Re: Materialized Views with refresh in 8.1.7

Re: Materialized Views with refresh in 8.1.7

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 13 Jul 2006 19:30:53 +0200
Message-ID: <e95vpj$cp3$2@news6.zwoll1.ov.home.nl>


Cosimo schreef:

> The jobs are ok.
>
> if I define the materialized view "refresh force" or "refresh fast" do
> not return any error, but do not work.
>
> If I define the materialized view "refresh complete" then work.

Odd - force means "try fast, if it fails, do complete", and complete works.

What jobs are OK? Did you run them manually?

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Thu Jul 13 2006 - 12:30:53 CDT

Original text of this message

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