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 Wed Nov 24 1999 - 15:05:18 CST
