In addition to maintaining referential integrity of the production database, the archiving or purging processes must ensure that critical data is not archived or purged along with non-critical data stored on the same tables. It is important to understand system functionality and business processes to determine impact of archiving or purging production data.
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.