Manually purging old undo data
In addition to a scheduled, periodical purge of your old undo data, you can also run a SQL script to remove all undo data older than a specific number of days (defaults to 7).
Procedure
- Access your installation and media and navigate to the folder Database\Scripts\.
- Do one of the following:
- If you are using an Oracle database, navigate to the subfolder Oracle\Tools\.
- If you are using a SQL Server database, navigate to the subfolder MSSQL\Tools\.
- To change the minimum age for purging, open the SQL script file Undo_Cleanup.sql for editing and change the value of
prune_periodto any value from 1 to 10000. The value you specify is a number of days: all undo data older than that number of days will be purged. - Save and close the SQL script.
- To purge all undo data older than the number of days specified in
prune_period, run the script.