8.6.4.4.1 Daily Partitioning Alternative

The Data Retention Manager also enables you to build five daily partitions only a weekly basis rather than daily.

You do this by executing the run_drm_utility.sh shell script and setting the drm_weekly_proc_flg parameter to Y (For more information, see Configuring the Data Retention Manager).

The Data Retention Manager also enables you to build five daily partitions only a weekly basis rather than daily.

This procedure eliminates the need to perform frequent index maintenance; Oracle recommends doing this for large market tables.

This approach builds the daily partitions for the next week. When creating the five daily partitions on a weekly basis, the Data Retention Manager should be executed prior to the end of the current week, to create partitions for the next week.

Note:

You must set the WEEKLY_ADD_FL parameter in the KDD_DR_MAINT_OPRTN table to Y so that the procedure works correctly. For more information about this parameter, see Configuring the Data Retention Manager.