Archiving and Purging by Retention Days
The following scripts are provided to archive and purge records based on the specified number days. The UNIX versions of these scripts have a .sh extension.
-
purge_by_days.cmd - Purges the history data by the specified number of days.
-
arch_by_days.cmd - Archives the history data by the specified number of days.
To purge records based on days
-
Open a command window and navigate to the directory where you downloaded the scripts.
-
Do one of the following:
-
For Oracle and DB2 databases, enter the following command:
purge_by_days user password database days
-
For Sybase and SQL Server databases, enter the following command:
purge_by_days user password server database days
Where days is the number of days to retain. For example, if you specify 4 days, then any records older than 4 days are purged.
-
To archive records based on days
-
Open a command window and navigate to the directory where you downloaded the scripts.
-
Do one of the following:
-
For Oracle and DB2 databases, enter the following command:
arch_by_days user password database days
-
For Sybase and SQL Server databases, enter the following command:
arch_by_days user password server database days
Where days is the number of days to retain. For example, if you specify 4 days, then any records older than 4 days are archived.
-
- © 2010, Oracle Corporation and/or its affiliates