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:
- Make sure ITEM_LOC_HIST is an interval range partition.
- Make sure the dates associated to that partition fall within the purge criteria for HSTPRG.
- Run HSTPRG.
- 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