HSTPRG Batch Fails To Drop The Last Partition From ITEM_LOC_HIST Table Which Meet The Purge Criteria
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.
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
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