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 Received on Tue Sep 20 1994 - 17:59:18 CEST
If anyone can help I'd sure be grateful
Original text of this message