Table of Contents

Search

  1. Preface
  2. Introduction
  3. Working with Enterprise Data Manager
  4. Enterprise Data Manager
  5. ILM Repository Constraints
  6. Partition Exchange Purging
  7. APIs
  8. Smart Partitioning
  9. Salesforce Accelerator
  10. SAP Application Retirement Entities
  11. Import Formats for Constraints
  12. Glossary

Enterprise Data Manager Guide

Enterprise Data Manager Guide

Partition Exchange Purging Overview

Partition Exchange Purging Overview

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.

0 COMMENTS

We’d like to hear from you!