Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Materialized Views with refresh in 8.1.7
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...
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