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 highly a 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.