Symptoms

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.

Cause

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