How to clear out old WWV_FLOW_FILES
spuchcJan 18 2012 — edited Jan 18 2012I'm updating an application that does a file upload into wwv_flow_files and then puts the data into a collection which is maintained thru a series of forms.
The application has DELETE_ALL_COLLECTIONS to handle the clearing out of the collection and our Purge Sessions is set at a day.
The problem I see is the application doesn't have a delete for the on the WWV_Flow_Files table for the data loaded.
How can I delete the old data, or do I have to now delete the data from WWV_FLOW_FILE_OBJECTS$ for the ID's I know should be deleted?
Does the Admintrator tool have a purge on WWV_Flow_Files like the Purge Sessions?
Thanks
Edited by: spuchc on Jan 18, 2012 4:25 PM