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: Cosimo <REMOVEMEclongo4_at_inwind.it>
Date: Thu, 13 Jul 2006 16:36:25 +0200
Message-ID: <44B65A69.8070904@inwind.it>


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. Received on Thu Jul 13 2006 - 09:36:25 CDT

Original text of this message

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