Archiving or purging records from a production data table could affect balances and quantities that are calculated from details. There are various ways to handle these situations, and each situation must be treated individually.
There are very few cases where calculated or stored aggregate summaries exist in the system. The sample archive procedures deal with the most complex instances of aggregate summaries that exist in the system, which are those that deal with financial data.
There are different ways of dealing with aggregate summaries, and they may be used in combination:
Copyright © 2000, 2015, Oracle and/or its affiliates. All rights reserved. Documentation build: 2.19.2015 16:18:51 [F1_1424305131000]