When designing an archive or purge procedure, choose a primary maintenance object to archive. If you have added custom tables and maintenance objects, make sure they have been configured with all relevant constraints. When configuring DB processes, remember that parent records should be archived or purged with all of their children even when they cross maintenance object boundaries. Constraints linking maintenance objects are very important.
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.