My Oracle Support Banner

SQL to Delete ITEM_HISTORY and CHANGE_HISTORY data Older Than Six Months (Doc ID 1146512.1)

Last updated on MARCH 29, 2022

Applies to:

Oracle Agile PLM Framework - Version and later
Information in this document applies to any platform.


Is there SQL to delete data in the CHANGE_HISTORY and ITEM_HISTORY tables and leave only history within the recent 6 months.
In development or test environments do not need to keep all the history from the production system.
Would like to delete old history data to make the database size small.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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