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 JANUARY 22, 2018

Applies to:

Symptoms

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:

1. Make sure DAILY_SALES_DISCOUNT is an interval range partition.
2. Make sure the dates associated to that partition fall within the purge criteria for HSTPRG batch.
3. Make sure that you have only one partition for DAILY_SALES_DISCOUNT
4. Run HSTPRG.
5. 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

Cause

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