Hello -
While I am not a dba, I administer machines that have filesystems that are near capacity with oracle dbf files - there are discussions to purge old data from databases - is there any oracle or third party tool to identify old/unused/unaccessed data in the databases (sort of like you can run a find in a unix filesytem of all files that have not been modified in 90 days...?) I have been reading that maybe it is possible if auditing is turned on - can anyone expand on that? Some have said only way is to have development teams write sql to identify/purge - is this true? Thanks and sorry if this is obvious but i have not seen a tool that can provide this function...