Re: STATSPACK PURGE

2002-04-04 Thread Tim Gorman
, save_action);   raise_application_error(-2, errcontext || ': ' || errmsg);  -- end PURGE; --end SPPURPKG;/set termout onshow errors   spool off - Original Message - From: Reddy, Madhusudana To: Multiple recipients of list ORACLE-L Sent: Thursday, April

STATSPACK PURGE

2002-04-04 Thread Reddy, Madhusudana
Hello All, I have a need to purge the old statistics accumulated by statspack and I am manually using the 'SPPURGE" ( I pass 'losnapid' and 'hisnapid' ) utility , instead I would like have a PL/SQL program which can be automated  through DBMS_JOB . Would somebody help me in this .   Thanks in