Salmaint Batch Does Not Rebuild Sub Partitions for WEEK_DATA And MONTH_DATA
Last updated on SEPTEMBER 20, 2016
Applies to:Oracle Retail Merchandising System - Version 13.1 to 13.1.8 [Release 13.1]
Information in this document applies to any platform.
salmaint batch calls rebbuild_unusable instead of rebuild_unusable_sub for WEEK_DATA and MONTH_DATA table.
Even though the partitioning spreadsheet provided by Oracle (the file RMS_partition_definition.xls) calls for subpartitioning week_data and month_data, the salmaint program calls the rebuild_unusable Pro*C library routine instead of rebuild_unusable_sub. When salmaint runs, indexes PK_WEEK_DATA, WEEK_DATA_I1, PK_MONTH_DATA and MONTH_DATA_I1 are all left in unusable condition.
Steps to Reproduce:
1. Sub-partition WEEK_DATA and MONTH_DATA per partitioning spreadsheet.
2. Run salmaint for a period that require it to drop/add partitions.
Indexes will be left in UNUSABLE state because rebuild_unusable does not rebuild them, only rebuild_unusable_sub can do this and it is not what is being called for these two tables in salmaint.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms