Re: Snapshots auto Refresh

In article <94263.165918RCAMPBEL_at_ESRIN.BITNET>, <RCAMPBEL_at_ESRIN.BITNET> writes:
> when using the DBMS_SNAPSHOT.REFRESH_ALL to refresh the snapshots on our
> DB ( from oracle user system), I do not recieve an error message only
> 'PL/SQL procedure successfully completed', but nothing appears to have been
> updated.The only way I can get the snapshot to update is to run
> DBMS_SNAPSHOT.REFRESH('snapshot_name') from the snapshot owners user. Another
> limitation (from my understanding anyway) is that because the NEXT update
> needs to be specified as a date format, it can only be run once a day (
> unless you are constantly ALTERING the snapshot refresh period).
>
> If anyone can help I'd sure be grateful

You can set the refresh period to be smaller than 1 day.

Say you wanted to have the snapshot refreshed 1pm every day. Then NEXT clause would be

        trunc(sysdate) + 1 + 13/24

The 'trunc(sysdate)' takes you to be beginning of today. The '+1' takes you to tomorrow. The '13/24' takes you to 1pm. Pretty friendly syntax, eh?

Can't help you much with the refresh all problem.

-- 
Bob Swisshelm                | swisshelm_at_Lilly.com     | 317 276 5472
Eli Lilly and Company        | Lilly Corporate Center  | Indianapolis, IN 46285