HSTPRG Batch Fails To Drop The Last Partition From ITEM_LOC_HIST Table Which Meet The Purge Criteria

(Doc ID 2349185.1)

Last updated on JANUARY 17, 2018

Applies to:

Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.

Symptoms

When HSTPRG batch attempts to drop the last partition from ITEM_LOC_HIST table which meet the purge criteria, it fails to drop the partition generating the following error:


Steps to Reproduce:

  1. Make sure ITEM_LOC_HIST is an interval range partition.
  2. Make sure the dates associated to that partition fall within the purge criteria for HSTPRG.
  3. Run HSTPRG.
  4. Notice the error message:
    hstprg_1~20170918084601~purge_item_loc_hist~ITEM_LOC_HIST~-14758~ORA-14758: Last partition in the range section cannot be dropped~EXECUTE DYNAMIC STATEMENT ALTER TABLE RMS01.ITEM_LOC_HIST DROP PARTITION ITEM_LOC_HIST_MIN UPDATE INDEXES

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