My Oracle Support Banner

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:

  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




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

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