Data Archiving

Data Archiving is a way of moving data from a production database to a specified data archive destination. The main purpose is to reach better performance by moving data from tables with large amount of data to a data archive destination. Data archiving set up is made by defining data archive objects and data archive orders. Data archive objects hold information about which database tables to archive and how to archive the data. Data archive orders hold information about when to execute data archive orders and which data archive objects to be executed at a certain time. Data archiving also consists of a log for viewing what has been executed and the result of the execution.

As of today there is no way of viewing the archived data in the normal client forms. To view the archived data you need to design special client forms.

Read more about the concept Data Archiving

Note: If the archive destination is Oracle table it is possible to view the data with SQL*Plus or a similar tool. If the archive destination is SQL File one must rely on an editor or similar tools maintained by the operating system to view the data.

Contents