Remove Rows from Item History in Two Steps on Agile Product Lifecycle Management (PLM) System (Doc ID 2863834.1)

Last updated on NOVEMBER 25, 2024

Applies to:

Goal

Remove unneeded or outdated change history records/rows from ITEM_HISTORY table in two steps. The first step can be performed while the system is in use and the second step can be done during the maintenance window. The bulk of the work is done during the first step to minimize the downtime required by the second step.

Scope
This document applies to the following products and versions:

• Oracle Agile PLM version 9.3.6
• Oracle Agile PLM version 9.3.3, 9.3.4, and 9.3.5 

Purpose
Agile PLM maintains a product record for all Items, Changes, Events, and Actions in the form of history records in the database. Systems that have been in use for many years will have large number of records in the various history tables. These tables tend to be large in size and utilize the most storage on the database. If the retention period limit for the older records has been reached, they can be purged from the system to reduce the size of these tables. Reducing the size of these tables will reclaim space, improve performance and manageability. The purpose of this Knowledge Management (KM) article provides a set of scripts to list and remove rows from the ITEM_HISTORY table on an Agile PLM system.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.