Archive data The archive application moves data that is no longer necessary for immediate day-to-day access from primary tables into a set of archive tables. The longer an instance runs, the more likely it is to accumulate data that is no longer relevant to current business needs. For example, task records from two years ago are typically less relevant than currently active tasks. Old data may eventually cause performance issues by consuming system resources and slowing down queries and reports. If you cannot delete this data because you need it for auditing or for historical purposes, archive the data to remove it from immediate access and free up system resources. Data archiving supports domain separation. For example, incidents that belong to a domain keep their domain designation even after they are archived.Figure 1. Sample Benefits of Archiving Data To setup data archiving: Activate the Data Archiving plugin. Create an archive rule for the table you want to archive. Define how the archive rule handles related records. Verify how many records the archive rule affects. Activate the archive rule. Activate data archivingThe Data Archiving plugin installs the System Archiving application.Create an archive ruleThe System Archiving application includes several sample archive rules that illustrate the archive features.Tables and modules created by an archive ruleThe first time you activate an archive rule, it performs the following actions:Change an archive scheduleAll active archive rules are executed by a system scheduled job set to run every 60 minutes. You can modify the job if you need to change the interval.Query archived tablesArchived tables are not optimized for ad hoc queries. They only contain index entries for the display value, creation date, and the primary key of sys_id.Setting the language of archived stringsOn internationalized instances, the archive process uses the language of the SYSTEM user to select the display value strings.Verify the number of records affectedEach archive rule provides an estimate of the number of records the rule affects in the Record estimate field.Archive related recordsUse the Archive Related Records related list to add related records to the archive rule.Archive a restored recordArchive rules will not archive restored records. In order to archive a restored record you must manually archive the record. View archived dataYou can view archived tables from the Archived Tables list.Restore archived dataWhen you restore a record, the instance inserts it back into the primary table and flags the record as having been restored in the log.