Cosimo wrote:
> Krishna ha scritto:
>> Hi Friend,
>> Please check the table user_jobs in replication site. There find the
>> status of the job related to the Materialized view name, it may be
>> broken. Re-execute the job again using "exec dbms_job.run(job)". you
>> can get job value from user_jobs table.
>> This may occur when there is 16 continuous failures on the job.
>> Regards,
>> Krishna
>>
>>
>>
>>
>> Frank van Bortel wrote:
>>> 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...
>>
> 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.
I had so many problems with materialized view refreshes in v8, and
snapshot refreshes in v7 that I gave up on them entirely. I hear the
actually work in 9i and 10g but haven't tried them myself.
Received on Thu Jul 13 2006 - 13:15:28 CDT
