HSTPRG Batch Fails To Drop The Last Partition From DAILY_SALES_DISCOUNT Table Which Meet The Purge Criteria
(Doc ID 2349142.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 DAILY_SALES_DISCOUNT table, it fails to drop the partition with error:
Steps to Reproduce:
- Make sure DAILY_SALES_DISCOUNT is an interval range partition.
- Make sure the dates associated to that partition fall within the purge criteria for HSTPRG batch.
- Make sure that you have only one partition for DAILY_SALES_DISCOUNT
- Run HSTPRG.
- Notice the error message:
hstprg_1~20170920012343~purge_discount_hist~DAILY_SALES_DISCOUNT~-14083~ORA-14083: cannot drop the only partition of a partitioned table~EXECUTE DYNAMIC STATEMENT ALTER TABLE RMS01.DAILY_SALES_DISCOUNT DROP PARTITION DAILY_SALES_DISCOUNT_P1 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