My Oracle Support Banner

SQL to Delete History Related Table Data Older Than Six Months (Doc ID 1146512.1)

Last updated on OCTOBER 23, 2023

Applies to:

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

Goal

Is there SQL to delete records older than 6 months from below History related tables and leave only the history records within the recent 6 months?

- CHANGE_HISTORY
- ITEM_HISTORY
- EVENT_HISTORY
- ADMIN_HISTORY
- ADMIN_HISTORY_DETAILS
- USER_USAGE_HISTORY


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 smaller.

Solution

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
Goal
Solution
References


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