Documentation Center

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

  1. Access your installation and media and navigate to the folder Database\Scripts\.
  2. 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\.
  3. To change the minimum age for purging, open the SQL script file Undo_Cleanup.sql for editing and change the value of prune_period to 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.
  4. Save and close the SQL script.
  5. To purge all undo data older than the number of days specified in prune_period, run the script.