Differences Between Purge and Delete Files?
I Have Looked It up but Haven't Been Able to Find Many Differences Between Purging and Deleting a Set of Files. Is There More to Purge Than Simply Backup and...
I have looked it up but haven't been able to find many differences between purging and deleting a set of files. Is there more to PURGE than simply BACKUP AND DELETE?
EDIT: Specifically, this is about trace files and log files in Oracle
3 Answers
Purge runs on a regular basis. It delete things that marked as delete. You can set up criteria. For example, you can set criteria that to remove all the rows have a flag as delete, and remove those rows from a table.
Delete removes the rows on going. For example, if you have a work queue, and the tasks will be finished after the queue, you can delete those rows since they are not needed anymore.
Purge Process
Purging is the process of freeing up space in the database or of deleting obsolete data that is not required by the system. The purge process can be based on the age of the data or the type of data.
Archive Process
Archiving is the process of backing up the obsolete data that will be deleted during the purge process. During the archive process, data will be moved from the main transactional tables to the backup tables
--some situations allow only soft DELETE, means the record is not deleted permanently and can be revovered later.
-- PURGE is for deleting permanently and cannot be recovered later.
David Miller brings 15 years of experience in global economics, personal finance strategy, and market dynamics. He specializes in turning complex economic trends into actionable insights for everyday readers.
