You can use Oracle partition exchange to delete data from sources on Oracle databases, version 10g or later. Configure partition exchange when you want to delete a significant percentage of the source data. For example, you want to delete twenty to thirty percent or more records from the source table.
Partition exchange increases the performance of the archive job when the job deletes data from the source. When you use partition exchange, the archive job calls a procedure that creates a partition for the records to keep in the source. The procedure swaps the original source segment with the new partition. It is more efficient to swap partitions than to individually delete a large amount of records from the source.
You can configure partition exchange for applications on Oracle databases that support partitioning. You can use partition exchange to delete data from partitioned and non-partitioned source tables. You can use partition exchange for archive and restore jobs.
Configure the entity to use partition exchange. When the archive job deletes data from the source, the job uses partition exchange for the tables that you configured in the entity. The job uses individual record deletion for the remainder of the tables in the entity that are not configured for partition exchange.
You can also disable or delete the configuration if you want do not want jobs to use partition exchange.