| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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
 |
 |