Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> help! dbms_refresh.make
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 Sun Nov 28 1999 - 20:25:41 CST