Thursday, 10 September 2015

Daily Queried to perform purging OSB DB



+++++++++++++++++++++++
p11676998_111130_Generic
+++++++++++++++++++++++

BEGIN
CMS_ORASDPM.UMS_CLEANUP.PURGE(200);
END;
/

+++++++++++++++++++++++
CR325307utility
+++++++++++++++++++++++


DECLARE
amount NUMBER;
BEGIN
REMOVE_REPORT_DATA_OLDER_THAN(50, 1000 ,amount);
dbms_output.put_line(amount);
END;

No comments:

Post a Comment