the point is that you choose : you can either refresh your snapshot and let Oracle clean the snapshot log, OR you can purge manually.
It seems that what you want is :
exec dbms_snapshot.refresh('name of your snapshot','C');
this will make a complete refresh of your snapshot




Reply With Quote