This chapter covers the following topics:
Oracle Install Base provides the functionality to view the history of changes to an item instance in the Transaction link and the History link. Although this is an extremely useful feature, the storage of this data makes up the bulk of data tied to an instance, especially if the instance has a long transaction history. For instances with frequent changes and a long transaction history, older, historical transactions consume significant storage space. In certain cases this has an adverse impact on performance. To address these issues, the application provides a utility to purge history transactions tied to an instance. Given a start date, you can run the utility to purge all the transaction data with dates older than the specified date and store the data in a table.
Use this procedure to purge all transaction data with dates older than a specified date and store the data in a table.
Warning: Be extremely careful when using this program. After you have purged transactions, the application cannot automatically restore them.
Using the Oracle Install Base Admin responsibility, select Others > Requests.
Navigate to the Install Base Requests window.
From the Name LOV, select Install Base Transactions History Purge. The Parameters window appears.
In the Purge_to_Date parameter, enter the date before which transaction data will be purged, and click OK.
In the main window, enter other values as desired.
Click Submit.