HSTPRG Batch Fails To Drop The Last Partition From DAILY_SALES_DISCOUNT Table Which Meet The Purge Criteria
Last updated on JANUARY 22, 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 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
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