This document describes how to configure a Data Archive entity to drop or truncate partitions from a source table in an Oracle database. You can drop and truncate partitions in Oracle databases that have partitioning enabled. Drop or truncate partitions instead of issuing the DELETE statement against the table. Dropping or truncating table partitions replaces the delete step of the archive or purge process. When you drop or truncate partitions, you remove or disable the delete step for that table. Data Archive quickly removes the data from the source table with little overhead. Dropping or truncating partitions helps improve the Delete from Source performance of the archive and purge process.
When you truncate a partition, Data Archive removes all data from the partition. After you truncate a partition, you can add data to the partition. When you drop a partition, Data Archive permanently removes all data from the partition and removes the partition from the table.