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:

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

Changes

Cause

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