Referential integrity of the production database must be maintained after archiving or purging. Imagine if bill records were purged and bill segment records were not. Some bill segment records would reference non-existent bill records in the production database. To effectively archive or purge production data without causing system problems, it is important to understand the system's data model.
Archiving or purging production data requires analysis of table dependencies. When choosing data to archive, a primary production maintenance object is selected. All of the table relationships related to the maintenance object must be analyzed. Rules for handling different table relationships during archiving or purging are necessary.
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.