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: Wed, 12 Jul 2006 20:21:42 +0200
Message-ID: <e93ecq$ptk$2@news2.zwoll1.ov.home.nl>


Cosimo schreef:

> frank.van.bortel_at_gmail.com ha scritto:

>>
>> Any errors would be helpful...
>>
>> 10 seconds may be a bit fast, and on commit didn't work in 8iRel3.
>>

> No errors, the creation of MV work fine, but no rebuild.

try to execute the job manually:
dbms_mv.refresh(upper('mv_aspiag_scontrino_general')); and see what gives

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Wed Jul 12 2006 - 13:21:42 CDT

Original text of this message

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