8.6.4.2 Executing the Data Retention Manager

To execute Data Retention Manager, use the following procedure. Be sure to run the utility when users are not working on the system. To avoid conflicts, Oracle recommends that you use this utility as part of the end-of-day activities.

The Data Retention Manager should be executed nightly for Daily partitioned and Mixed-date partitioned table, after the calendar has been set for the next business day. For weekly and monthly partitioned table, the Data Retention Manager should be executed prior to the end of the current processing period. Oracle recommends running the Data Retention Manager on Thursday or Friday for weekly partitioned tables and on or about the 23rd of each month for monthly partitioned tables.

Note:

Be sure to set the system date with the Calendar Manager Utility prior to running the Data Retention Manager. For more information, see Configuring the Data Retention Manager.

Running the Data Retention Manager

To run the Data Retention Manager manually, follow the steps:

1. Access the directory where the shell script resides:

   cd <INSTALL_DIR>/database/db_tools/bin

2. Start the batch shell script with the parameters in Data Retention Manager Processing Parameterstable1.fm:

   run_drm_utility.sh <drm_operation> <drm_partition_type> <drm_owner> <drm_object_name> <drm_weekly_proc_fl>

   Script Examples:

   The following are examples of running the script:

   • To run the utility for all daily tables in the BUSINESS schema, execute the script:

     run_drm_utility.sh P D BUSINESS A N

   • To run the utility to drop a monthly partition of the BUSINESS table ACCT_SMRY_MNTH, execute the script as follows (using the same parameters as in the previous example):

     run_drm_utility.sh DM M BUSINESS ACCT_SMRY_MNTH N