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
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...
Received on Thu Jul 13 2006 - 08:53:40 CDT
![]() |
![]() |