,
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
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