Truncating Old Partitions
Truncating old partitions is only supported for Oracle databases.
- Oracle EE users:
A truncate partition script is provided for an Oracle EE database. Truncate partitioning lets 24/7 up time of the database when partitions are being truncated and indexes are being updated. Refer to the Partition_Truncate_Readme.txt file under $OM_HOME/db/oracle/purge for additional details on the setup and run procedure.
Note: Even though partitions can be truncated when the database is serving OLTP requests, it is a highly good practice to run the truncation script when either the database is under a minimal load or disconnected from the front end for other maintenance.