My Oracle Support Banner

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 OCTOBER 15, 2020

Applies to:

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


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




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.