gotchaMinor
What is the Difference between Archiving and Purging in Oracle database?
Viewed 0 times
thewhatarchivingpurgingdifferencedatabasebetweenandoracle
Problem
I would like to know the main difference between Archiving and Purging in any database we use.
Solution
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.
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.
Context
StackExchange Database Administrators Q#54516, answer score: 8
Revisions (0)
No revisions yet.