A utility called ArcSetup is provided to maximize performance. Run this as a pre-archive task with action type B. This utility generates the DDL for the tables that are associated with archive DB Processes resulting in the scripts Gen_Index.sql and Enable_Pkey.sql. It then drops indexes and disables primary key constraints for tables associated with archive DB processes.
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.