OraOpenSource/Logger

Include logger_logs_apex_items in purge procedure

martindsouza opened this issue · 1 comments

From @shakerlxxv on October 20, 2013 2:50

Add the logger_logs_apex_items table to the purge() procedure to keep things cleaned up.

Copied from original issue: tmuth#54

This should already occur as part of the logger.purge process. logger_logs_apex_items has a foreign key to logger_logs which uses the ON DELETE CASCADE option. This means that each time the parent item in logger_logs is deleted, the associated values in logger_logs_apex_items is also deleted.

To confirm:

-- Look at the DELETE_RULE column
select *
from user_constraints
where constraint_name = 'LOGGER_LOGS_APX_ITMS_FK';