Patrick Wolf
-
2007-01-09
- summary: Create a ApexLib_Admin package --> Create an ApexLib_Admin package
This package could include some admin functions, like clearing obsolete files in wwv_flow_file_objects$ see http://iadvise.blogspot.com/2007/01/apex-housekeeping-your-flow-files-in.html for details.
Example delete:
DELETE wwv_flow_file_objects$
WHERE security_group_id = 0
AND flow_id = 0
AND file_type IS NULL
AND created_by < sysdate-1
;