Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help! dbms_refresh.make
You mign need to increase job_queue_processes.
HTH,
Michael Daskaloff
kal121_at_my-deja.com wrote:
> Below is a test I was trying to run. The refresh group should refresh
> for the first time at sysdate plus two minutes, then every half hour
> thereafter - but it does nothing. Yes, a manual refresh works and
> everything is set up correctly. I've been through the checklist of
> common problems... but it still does not run when it's supposed to.
> Anybody seen this problem before?
>
> BEGIN
> DBMS_REFRESH.MAKE(
> name = 'refgrp_1',
> list = 'partner',
> next_date = SYSDATE + 2/1440,
> interval = 'SYSDATE + 1/48',
> implicit_destroy = TRUE,
> rollback_seg = 'rbs_large'
> );
> END;
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Dec 06 1999 - 11:04:29 CST