APEX

Hi,

We need to clean up wwv_flow_file_objects$ table as the size of the table is very big and we have decided to delete the files from this table once we insert into our local tables from now on. We can do it by placing the delete statement delete from apex_application_files where name = :PX_FILE_BROWSE_ITEM. But our application has so many file browse items and we need to change in so many processes. So we decided to have some job which will run daily and delete the files uploaded through file browse items from our application. Can we use the below statement
SELECT * FROM wwv_flow_file_objects$ WHERE security_group_id = XXXXXXXXXX AND file_type IS NULL and FLOW_ID = 0 (do not want to delete application import and export files and want to delete the files from specific workspace). IS above statement will delete application static files, images or CSS files?. Or willl cause any problem to existing application ?. Please suggest the best way to do.

Thanks in advance for your help.

Regards
Ram